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