Forumunuz.Com - sql server attach detach

Forumunuz.Com (https://www.forumunuz.com/)

- Webmaster Forum (https://www.forumunuz.com/webmaster-forum/)

- - sql server attach detach (https://www.forumunuz.com/webmaster-forum/17411-sql-server-attach-detach.html)

Kaf Dağı

27 Mart 2015 15:32

sql server attach detach

Kod:

EXEC sp_detach_db 'pubs', 'false'

 

 

EXEC sp_attach_db @dbname = 'pubs',

     @filename1 = 'C:\MSSQL\Data\pubs.mdf',

     @filename2 = 'C:\MSSQL\Data\pubs_log.ldf'

 

 

 

EXEC sp_attach_single_file_db @dbname = 'pubs',

     @physname = 'C:\MSSQL\Data\pubs.mdf'

Tüm Zamanlar GMT +3 Olarak Ayarlanmış. Şuanki Zaman: 08:54.