----------------------------------------------------------------------------------------
: "Could not find server ' ' in sysservers. Execute sp_addlinkedserver" 
----------------------------------------------------------------------------------------
: 
- ,    SQL Server    @@servername
	select @@servername
-      ,    
	sp_dropserver <,     @@servername>
	sp_addserver < >,local
-  SQL Server

----------------------------------------------------------------------------------------
:        MDF 
----------------------------------------------------------------------------------------
:
-  MDF         :
	create database teserver on (filename = 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\TEServer.mdf') 
	for attach_rebuild_log [ attach]

	sp_attach_single_file_db @dbname = 'TEServer', 
		@physname = 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\TEServer.mdf'

----------------------------------------------------------------------------------------
:  MSSQL     
(   :  COM+ )
----------------------------------------------------------------------------------------
:
1.       :
2. "net stop msdtc"  
3. "msdtc -resetlog"  
4. "net start msdtc"  
  
  :
  
1. "net stop msdtc"  
2. "msdtc -uninstall"  
3.  ,  HKLM/Software/Microsoft/Software/MSDTC  HKLM/System/CurrentControlSet/Services/MSDTC 
4. "msdtc -install"  
5. "net start msdtc"  

------------------------------------------------------------------------------------------
:    TEServer
------------------------------------------------------------------------------------------
   :
alter database teserver set emergency
go
alter database teserver set single_user with no_wait ( sp_dboption teserver, single, true)
go
dbcc checkdb(teserver, REPAIR_REBUILD [  ,    REPAIR_ALLOW_DATA_LOSS]) with no_infomsgs, all_errormsgs
go
alter database teserver set multi_user with no_wait ( sp_dboption teserver, single, false)
go
alter database teserver set online
go
-------------------------------------------------------------------------------------------
        
-------------------------------------------------------------------------------------------
:
osql -S SQL -U  -P  -Q "BACKUP DATABASE TEServer TO DISK='\\\\TEServer.dat' WITH INIT"
:
osql -S SQL -U  -P  -Q "RESTORE DATABASE TEServer FROM DISK='\\\\TEServer.dat' WITH REPLACE"
-------------------------------------------------------------------------------------------
:   msdb, master, tempdb . 
-------------------------------------------------------------------------------------------
-  SQL   NET STOP MSSQLSERVER
-  SQL      NET START MSSQLSERVER /m  NET START MSSQLSERVER /f
-   dbcc checkdb    
-  SQL 
-------------------------------------------------------------------------------------------
:   msdb .   'msdb'
-------------------------------------------------------------------------------------------
-  ,     Database Engine,   SQL Server,  SSRS,   SSIS   ,  SQL Server   . 
- SQL Server      : NET START MSSQLSERVER /T3608 
-        msdb,   ,   <servername>  SQL Server: SQLCMD -E -S<servername> -dmaster -Q"EXEC sp_detach_db msdb" 
-   Windows     msdb.       DATA   SQL Server. 
-    SQL Server       Database Engine,  . 
-       SQL Server    : SQLCMD -E -S<servername> -i"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install\instmsdb.sql" -o" C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install\instmsdb.out" 
-    instmsdb.out       . 
-       ,     . 
-      msdb,    ,   . . 
--------------------------------------------------------------------------------------------
:   windows authentification:      
--------------------------------------------------------------------------------------------
create login [<<DOMAIN\USERNAME>>] from windows;
-- For older versions of SQL Server:
EXEC sys.sp_addsrvrolemember @loginame = N'<<DOMAIN\USERNAME>>', @rolename = N'sysadmin';
-- For newer versions of SQL Server:
ALTER SERVER ROLE [sysadmin] ADD MEMBER [<<DOMAIN\USERNAME>>]
GO;