1 頁 (共 1 頁)

restore master database

發表於 : 2013年 3月 18日, 16:20
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;