restore master database

有關資料庫的討論, 都可以在這發表哦~~
回覆文章
arvin
文章: 21
註冊時間: 2009年 2月 16日, 15:00

restore master database

文章 arvin »

restore master database
1. sql server name: default or instance, sql server name need to be the same.
2. tempdb path: if not match, after restore the master database, we need to alter tempdb database file path
3. net stop mssql$instancename
4. net start mssql$instancename /m
5. sqlcmd -S servername\instancename
6. restore database master from disk = 'master.full_03-17-13.BCK' WITH REPLACE;
回覆文章