???? ??? ??????? ???? ????? ??? ????? ??? ????? ?????? Microsoft SQL Server ???????? ??????? Microsoft SQL Server ?????? ?????? ??? ????? ????????? ???? ???? Microsoft SQL Server.
????? ??????? ??????? ?? ??? ???????
??? ?? ???
??????????
???????
???????? ????? ?????? ??????
msdb . ???? ??????? ?????? ?????? ?????? ??
??? ??????? ?????? ????????? ?????? ?????? ???????? ?? ????? ????????
???????? ?
msdb .
?????? ??? ??????? ??? ?????? ??????? ???? ?? ??? ????? ??? ????? ??????? ???????? ?? ??? ???????? ???? ??? "???? ?? ?????????".
?????? ? SQL Server 2008? ????? ???
????? ???????? ??????? ??? ????? ????? ?????? ??? ???? ???? ???
(http://msdn.microsoft.com/en-us/library/ms187580.aspx)
???? ???? ????? Microsoft (MSDN).
?????? ??? ?????? ????? ???????? ?? SQL Server 2000 ??? Microsoft SQL Server 2000 (64-??). ????? ????? ????? ?????? 32-?? ?????? 64 ?? ???????? ????? ?????? ??????
sp_attach_db ?? ????? ?????? ??????
sp_attach_single_file_db ?? ???????? ????? ????????? ?????????? ?? ????? ??????? 32-??. ????? ??? ????? ???????? ????? ?????? ??? 32 ?? ???????? 64 ?? ?? SQL Server. ????? ???? ????? ???????? ?? SQL Server 7.0 ???????? ??? ????????. ??? ???? ????? ???????? ? SQL Server 7.0 ?? SQL Server 2000 (64-??) ??? ?????.
???? ??? ??? ??? ?????.
???? 1: ????? ??? ????? ?????? ????????
??? ??? ?????? SQL Server 2005? ????? ??????? ??? ??????? ???? ???????? ?? SQL Server 7.0 ?? SQL Server 2000. ??? ???? ????? ???? ????? ?? SQL Server 2005 ?? ???? ????? ?? SQL Server 7.0 ?? ?? SQL Server 2000. ??? ??????? Studio ????? ???? SQL ????? ?? ????? ??????? ???? SQL. ???????? ??? ???? ??? ??????? ?? SQL Server ????? ????????? ???????? (DTSWizard.exe) ????? ?? ??????? ????? ????? ???????? ?????? ????? ????????.
???? ????? ?????? ????????? ?????? ???? ????? ???????.
??????? 1: ????? ????????? ???????? ????? ?????? ????????
????? ??? ??????? ?????? ?????? ???????? ??? ?????? ?????? ??? ?? ???????
????? ?????? ???????? ??? ?????? ??????.
- ???? ??????? ????? ???????? ??? ????? ????? ?????????.
?? ???? ????? ?????????? ?????? ????? ?? ??? ???????? ?? ????? ???????? ???
?????? ????? ?????????? ?? ????? ????? ????????? ??? ??? ?????????. ??? ??? ???
??? ???? ?????????? ????? ??? ????????? ???? ???? ?? ???? ?????? ?? ??? ?????? ?? ????? ??? ???
????? ???? ???????? ?? ????? ?????? ????? ????? ???????? ??? ??????.
- ??????? ????? ????????? ????? ?????? ????? ??? ??????
?????? ??? ?????? ?????? NORECOVERY ?? .
?????? ???? ??????? ????? ???????? ????????? ????? ?????????? ??? ????? ???? ????? ???????? ??? ?????? ??????. - ????? ??? ??????? ??? ?????? ??????????
????? ????????? ??? ???????? ??? ?????? ?????? ???????? ???? ????????? ?? . ?????? ?? ????? ????? ??? ??? ??? ????????
????? ????????? ??????????. ?????? ??? ???? ?? ?????????? ???? ??????? ?????? "???????" ??
"Transact SQL Reference" ????? "??? SQL Server".
- ????? ??? ????? ???????? ??? ?????? ??????
??? ????? ???????? ??? ?????? ??????. ?????? ??? ????? ?????????
??? ??? ????? ????? ???????? ?????? ??? ????? ????? ?????????? ??
????? ????? ???????? ?????? ??? ?????? ?????????. ????? ?? ?????????
?????????? ???? ??????? ?????? "????? ????????" ?? "????? ?
???????? ?????? ?????? "?????" ??? SQL Server ".
- ??? ??? ???????? ????? ???????? ??? ???? ??? ?????
?? ????? ???????? ??????? ??? ???? ????? ?????? ???? . ??? ???? ??????? ??? ?????? ?????? ????? ???????? ???
???? D:\Mssql\Data. ??? ??? ?????? ?????? ???? ????? d? ?
???? ?? ??????? ????? ???????? ??? ?????? C:\Mssql\Data.????? ?? ????????? ??? ????? ??????? ????? ?????? ??? ?????
??????? ???? ??? ???? ????????? ???????? ??????? ?? ????? ????? Microsoft:
221465
(http://support.microsoft.com/kb/221465/
)
??????? ?????? "????" ?? ????? ?????????
304692
(http://support.microsoft.com/kb/304692/
)
??? ????? ?????? SQL Server 7.0 ??? ???? ???? ???????? ????? ????????? ??????????
- ??? ??? ???? ??????? ??? ????? ?????? ???????? ?????? ??? ?????? ??????? ??? ????? ?????? ?? ??????? . ?????? ??? ???? ?? ?????????? ???? ??????? ?????? "???????" ??
"Transact SQL Reference" ????? "??? SQL Server".
- ????? ?????? SQL Server ???? ???
????????? ??????? ?????? ?????? ??? ?????? Unicode ?? ????
???? ??? ?????? ?????? ???????. ?????? ??? ???? ?? ?????????? ????
"????? ??? ????? ?????" ?????? ?? ??? ??????.
??????? 2: ??????? sp_detach_db ? sp_attach_db ????????? ???????
????????
sp_detach_db ?
sp_attach_db ????????? ???????? ???? ??????? ???????:
- ??? ????? ???????? ??? ?????? ?????? ???????? ??????? sp_detach_db ?????. ??? ???.mdf ?. ndf ??????.ldf ???????? ?? ????? ???????? ??? ?????? ??????. ???? ??? ?????? ?????? ??? ??? ????? ???????:
?? ??? ??????????? ??? ??????
| ???? ??? ????? | ????? |
|---|
| .mdf | ??? ???????? ??????? |
| . ndf | ??? ?????? ????? |
| .ldf | ??? ??? ???????? |
- ????? ????? ???????? ??? ?????? ?????? ???????? ??????? sp_attach_db ??????? ???? ??? ??????? ???? ??? ?????? ??? ?????? ?????? ?? ?????? ???????. ????? ?? ????????? ??? ????? ??????? ???
??????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
224071
(http://support.microsoft.com/kb/224071/
)
????? ??? ????? ?????? SQL Server ??? ???? ???? ???????? ??????? ??? ?? ????? ?? SQL Server
- ????? ??? ????? ?????? ??? ???? ?????????
?? ???? ??????? ????? ???????? ????? ???? ???? ???????. ???? ???????? ???????? ??
??? ??? ????? ???????? ??? ???? ????? ???.
- ?????? ?????? ?????? Unicode ?? ????? ?????
??? ?? ???? ?? ????? ??? ????? ??? ??????? ??????? ????? ?? ??? . ????? ?? ?????????? ???? ???????? ??????? ???????? ????????.
????????? ??? ???? ????? ???????? ??? ?????? SQL Server 7.0 ???????? ????? ????????? ?????????? ?? ??????
????? ?
??? ? ?????? ?????? ?????? ??? ????? Unicode ??? ????? ??? ?????. ??? ??? ???? ????? ???????? ?? SQL Server 7.0 ??? SQL Server 2000 ?? ??? ?????? SQL Server 2000? ????? ????? ????? ??? ????? ???????? ??????. ??? ???? ??? ??? ??? ?????? ?????? ???? ???? ?????? SQL Server 2000 ?????? ????? ?? ????? ???????? ??????? ????? ???????? ?????? ????? ????? ?? ????? ????????
?????????
????????????
msdb ?????? ??????. ?????? ??? ???? ?? ?????????? ???? ????? ????? "
??????? "????? ?? ??? SQL Server 2000.
??????? 3: ??????? ?? ????? ????????? ???????? ???????? ???? ???????? ??? ????? ?????? SQL Server ?????????
????? ??? ????? ?????? ????? ?? ??? ???????? ???????? ?
?????? ?? ????? ???????? ?????? ??? ????? ???????? ?????? ???????? ??????
????? ????? ??????? ?????? ????? ????????.
- ?? ??? ??????? ????? ???????? ?????? ?????
???. ??? ?? ??????? ????? ???????? ?????? ????? ?????? ?? ????? ??? ??? ????? ???? ?????
??? ??????.
- ??? ??????? ????? ??? ????? ????????? ???????? ????????? ?????? ????? ??? ???? ????? ??? ???? ??? ?????? ?????? ??????? ??????.
- ????? ???? ????? ??????? ??? ????????? ?? ????? ???????? ???????
???? ?? ????? ???????? ?????? ????? ???? ????? ???????? ??????.
???????? ??? ??? ???? ??? ????????? ????? ???????? ?????? ?? ?? ????
?? ???? ????? ???? ????? ???????? ??????.
- ?? ???? "???? SQL 7.0 ????? ????? ????????"
??? ?? ????? ???????? ???? ?? 64 ???? ???? ???? ????. ??? ??????? ??
????? ????? SQL Server 2000 ????? ????? ????????.????? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
257425
(http://support.microsoft.com/kb/257425/
)
?????: "??? ????" DTS ?? ??? ??? ???????? BLOB ???? ?? 64 ???? ????
???? 2: ????? ????? ??????? ?????? ?????? ??????
??? ??? ?? ??? ??? ??????? ?????? ?? ?????? ??????
?????? ??????? ?? ???? ?????????? SQL Server ?????? ??? ???? ??? ????? ?????? ???
?????? ??????. ????? ??? ??????? ?????? ?????? ?????? ????????
??????? ?? ??????? Microsoft Knowledge Base
??????:
246133
(http://support.microsoft.com/kb/246133/
)
????? ????? ??????? ?????? ?????? ?????? ??? ?????? SQL Server
?? ????? ????? ?????? ??????? ??????? ????? ?????? ??? ?????? ?????? ?? ????? ???????? ?????????? ?????? ?????? ??? ?????? ??????. ????? ????? ????? ???????? ?????????? ?????? ???? ???????? ??????? sp_defaultdb ???????. ?????? ??? ???? ?? ?????????? ???? "sp_defaultdb"
??????? ?????? ??????? "???? Transact-SQL" ?? "??? SQL Server".
?????? 3: ????? ?? ?????????? ????????
??? ????? ??????? ?????? ?????? ?????? ?????? ???????
?? ????? ?????????? ?? ?????? ??? ????? ????????. ????? ??????? ?????? ???
?????????? ??? ???? ?????? (SID)? ??? ???? ??? ??????? ??? SID
??? ????? ??????? ?? ???? SQL Server ???????? ?????? ??? ????? ????????. ????
???? ??????? ??????? ?????. ??? ??? ???? ??????? ?????? ?????? ?????? ?? ????
???????? ???? "????? ?????? SQL Server 2000 DTS ??? ???"? ??? ????
?????????? ???????. ???????? ??? ???? ??????? ?????? ????????? ??? ?????? ??? ????
???? ???? ?? ???? ????? ?? ?????? ?????? ?????????? ???????.
- ???? ?? ?????????? ???????. ???? ???? ??????? ???
????? ?????? ?????? ??????? ??? ?? ????? ????????? ???????? ??????? ?? ???????? ???? ???
???:
exec sp_change_users_login 'Report'
- ?? ?????????? ???????. ??? ??? ??? ??? ??????? ????? ??????
????? ????? ?????? ??? ?????? ????? ?????????? ???? ??? ???? ?????
?????? ??? ????? ????????. ??? ????? ??? ?? ?????? ??? ????? ?????? ??? ????? ????????? ????
??? ???? ????? ??? ??? ???????? ????? ??????:
Microsoft SQL-DMO (ODBC SQLState: 42000) ??? 15023:
???????? ?? ????? '% s' ????? ?????? ?? ????? ???????? ???????.
240872
(http://support.microsoft.com/kb/240872/
)
????? ?? ?????? ????? ??? ??? ????? ?????? ??? ???????? ???? ???? ?????? SQL Server
????? ????? ????? Microsoft ??????? ??? ??????? ??? ????? ????? ??????? ?????? ??? ??????? ????? ???????? ???? ?????????? ??? ?? ??????? ???? SQL Server ???????? ???????? ??????? ??????:
274188
(http://support.microsoft.com/kb/274188/
)
"??????? ??????? ???????? ?????????? Orphaned" ????? ?? ??? ??? ?????
???? ??? ??????? ????? ??????? ??????? sp_change_users_login ????? ?????? ?????????? ??????? ?????? ??? ?????. ??? ??????? sp_change_users_login ????? ?????????? ??? ?? ??????? ???? SQL Server ???????? ???. - ??? ?? ??? ???? ????? ???????? (dbo) ????? ????? ??? ????????? ???????? ?? ????? ?????? ????????:
exec sp_changedbowner 'sa'
- ??? ??? ?????? ?????? ?????? SQL Server 2000
Service Pack 1? ???????? ???? ????? ???????? ?? ?? ?? ??????? ?? ?????? ?????????? ?? ????? ??????? ??? ????? ??????? ?? ??????? ?? ??????. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
305711
(http://support.microsoft.com/kb/305711/
)
???: ?? ???? ???????? DBO ?? ????? ???????
- ?? ????? ????? ????? ??????? ??? ??????
????? ???? ???? (SA) ????? ?????? ?? ???? ????? ??????? ?? ???? ????? ?????? ???? ?? ???????
??? dbo ??? ?????? server ??? ????? ??? ??????
??????:
??? 21776: [SQL DMO] ??? 'dbo' ??? ????? ?? ?????? ??????????. ??? ??? ????? ??? ????? ?????? [] ???? ????? ?????? ?? ????? ????? ??? ????.
218172
(http://support.microsoft.com/kb/218172/
)
?? ???? ????? ???? ???? ????? ?????? ?? ????? ???????
????? ??? ??? ???????? ?? ????? ????? ???????? ??? ????? ??????? ????? ????????
?? ???? ????????? ???? ???? ????? ?????? 3.
?????? 4: ????? ??? ???? ?????????? ?????? ???????
?????? 4 ????????. ????? ????? ????? ???? ????? ?????? ?????????? ?????? ??????? ??? ?????? ??????? ??? ?????? ???????? ????? ??? ?????? ??????.
- ???? ?????? ?????????? ?????? ???????? ???? ??? ???????:
- ??? ????? ??????? SQL Server? ?? ?? ??????
???? ??????? .
- ????? ???? SQL Server??? ?? ???? ????? ??????? ??? ????????? ???????? ????? ???????.
- ???? ??? ???? ????????? ?? ???? ??? ????? ?????? ??? SQL. ? SQL Server 7.0? ???? ??? ???????? ????? ????? ???????? ??????????? ????? ???????.
????? ???? ?????? ?????? ??????? ?????? ???? ?????????? ???? ??????? ?? ???? ??????? ???????? ??? ?????? ???? ??? ??? ?????? ??????. - ????? ??? ?????? ?????????? ?????? ??????? ?? SQL Server 7.0 ??? SQL Server 2000 ?? ??? ????? ????????? ???? ???? ?????? SQL Server 7.0 ? SQL Server 2000.
- ??? ??? ???? ????? ??????? ???? ?? ??????? ??????? ?? ????
SQLMail ??? ?????? ??????? ???? ?????? SQLMail ??? ??????
???? ?? ???? ???? ??? ???????.????? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
263556
(http://support.microsoft.com/kb/263556/
)
????? ????? ????????? SQL
???? 5: ????? ??? ??? DTS
?????? 5 ????????. ??? ???? ??? DTS ????? ??? ??????
???? ?? SQL Server ?? ????????? ????? ????? ??? ????. ???
??? ??? DTS ??? ????????? ?????? ???? ????? ???????.
??????? 1: ??? ???? DTS ??? ???? SQL
- ??? ???? DTS ??? ?????? ?????? ??? ???? ?
?? ???? ??? ?????? DTS ??? ?????? ??????.
- ??? ?????? ??? ?????? ?????? ??? SQL
??????? ?? ?? ????????.
?????? ????? ???? ????? ?? ???? ?????? ??? ????? ?? ????? ??????.
??????? 2: ??? ?????? DTS ?? ???? DTS
- ???? ?? ???? DTS ?? ???? DTS.
- ?? ??????? ???? , ???? ??? ??? ????.
- ??? ?????? SQL Server.
?????? ?? ?? ???? ?????? ???? ???? ??? ?????? ??????. ?? ???? ??? ????? ??????? ?????? ?? ????? ?? ?????? ???????? ????? ????? ???????? ?????? ??????? ???????? ???? ?????? ??? ?????? ?????? ??????? ???? ???? ?????? ???????. ??? ????? ??? ????????? ??? ???? ?????? ?? ???? ???????? ??? ????? ?? ????.
???? 6: ????? ??????? sp_configure ??????? ????????? ??????
?? ???? ??? ????? ????????? ???? ???? ????? ????????? ???????? ?? ????????? ??????. ??? ???? ??????? ??? ??? ??? ????????? ?????? ?????? ?? ??????? ?? ??? ??? ??? ??????? ?????? SQL ?????? ??????????? ?? ????? ??? ????? ????? ???????? ??????? ?????? ???? ?????? ?? ??????? AWE. ?? ???? ??? ????? ????? MAXDOP ??? ?? ????? ??? ????? ???? ???????? ???????? ???? ????? ??? ???? ???????.
?? ????? ??? ??? ??????? ?????? ??? ?????? ????????? ???????? ?????? ????????? ????? ???????? ?????? ????? ??????? ??????? ????? ????? ????????? ?? ??? ??????? ???????? ????????? ?????? ????????? ?????? ????? ????????? ?????? ???????? ????? ??????? ???? ???????? ???????? DDL ???? ???? (??? ???? ????? ????) ?? ??????? ?????? ???? ???? ???????? ?? msdb.
??? ?????? ?????? ???? ????????? ?????? ?????
?????? ????? ?????? ??? ?????? ??????? ??? ???
????.
????? ?? ????????? ??? ????? ??? ???? ??????
????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
240867
(http://support.microsoft.com/kb/240867/
)
????? ??? ???? ???????? ?? ??????? ????????? ?????? ???? ??????
?? ??? ??? ???????? ????????? ?????? ???????? ???????? ????? ????????? ?????????? ?? ???? ????? ??????? ???????? ?? ??? ???????. ??? ??? ??? ??? ??? ?????????? ???? ????? ?????? ??????
msdb . ?????? ??? ??????? ??? ????? ??? ????? ??????
msdb ? ???? ?????? ????? ????? Microsoft ?????? ????? ??
"?????? 1: ????? ??? ????????
?????? ????? ?????? ". ??? ??? ???? ????? ??????
msdb ? ??? ???? ??????? "?????? 4: ????? ??? ???? ?????????? ?????? ???????" ??
"?????? 5: ????? ??? DTS
???. "
????? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
320125
(http://support.microsoft.com/kb/320125/
)
????? ??? ??? ?????? ????? ??????
???? ???????: 314546 - ????? ??? ??????: 04/?????/1433 - ??????: 1.0
????? ???
- Microsoft SQL Server 2005 Standard Edition
- Microsoft SQL Server 2005 Express Edition
- Microsoft SQL Server 2005 Developer Edition
- Microsoft SQL Server 2005 Enterprise Edition
- Microsoft SQL Server 2005 Workgroup Edition
- Microsoft SQL Server 2000 Standard Edition
- Microsoft SQL Server 2000 64-bit Edition
- Microsoft SQL Server 7.0 Standard Edition
| kbsqlsetup kbhowtomaster kbmt KB314546 KbMtar |
????? ???????: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????
314546
(http://support.microsoft.com/kb/314546/en-us/
)
???? ??? ??????
