when I start SQL 7.0 with single user model and restore Master database
sqlservr -c -m
in QA use command:
restore database master from disk='c:\sqldbbackup\master.bak'
with move 'master' to 'e:\mssql7\data\master.mdf',
move 'mastlog' to 'f:\mssql7\log\mastlog.ldf',
Get error message:
Server: Msg 3708, Level 16, State 4, Line 1
Cannot drop the database 'master' because it is a system database.
Server: Msg 3166, Level 16, State 1, Line 1
RESTORE DATABASE could not drop database 'master'. Drop the database and then reissue the RESTORE DATABASE statement.
How can I do with this error, try to drop the master db, but fail???
Do not attempt to move master database, just restore using RESTORE statement.
Any database users previously associated with logins that need to be re-created are orphaned because the login is lost. To associate an existing database user to a new SQL Server login, see sp_addlogin. To associate an existing database user with a Windows NT user, see sp_grantlogin.