Experience restoring SQL with Arcserve?

[kldomino]

I have had a few miserable days trying to restore fully my SQL databases with Arcserve 2000. My data database restored ok, but after making a new temp master.mdf so that I could restore the master.mdf from tape, I have not been successful in TWO DAYS restoring the master.

The error I get in the dbasql.log is the database must be in single-user mode to restore. Though there is a wealth of data on how to do so when using SQL as the restore method, I find nothing related to Arcserve; the SQL agent in Arcserve does not seem to be setting it into single-user mode.

If I try to set it in single-user mode, then the SQL agent won't start, and I can't even talk to the SQL server from Arcserve.....

Any help out there? I have a consultant coming in Monday morning to fix some problems with application licensing afetr the restore, and I still have no master

Thank you,
Kelly

 

[lovalles]

Restore SQL Server 2000 MASTER Database
The MASTER database can only be restored when the database is in single-user mode. To place it in single user mode:

Start a command session.
To ensure that SQL Server is not running type:
net stop MSSQLServer
This may say that this will also stop another service, in which case allow it to continue. It will also indicate if the service is already stopped.
To start SQL Server in single user mode type:
sqlservr -m
If this is not recognised then cd to 'C:\Program Files\Microsoft SQL Server\MSSQL\BINN' and try again.

 

[kldomino]

Dear Lovalles,

Thank you for the post. I had used the sqlservr -m command to no avail on Saturday....when I put it in this mode this way, then the Arcserve SQL agent will not even connect to SQL to restore and it bombs. I really appreciate the reply though! I have resigned myself to reconfiguring the master (users/backups/etc.)

Kelly

 

[lovalles]

Well the other thing you can do is, SQL 2000 let you put any database you want in single user mode.

So put the mater in single user then restore it
Go to the Enterprise manager then select the SQL server and then select the database, on the Properties windows select the Option tab and select de Restric Access option, just select single user.

now Try no restore the master database. ArcServe should se the server.

Hope this help
lovalles