How can we help you today? How can we help you today?

Restoring Database with Ext Stored Proc

I've been trying to figure out how to restore databases with .SQB files. I can run the Ext SP fine but if I try to put the database into single user mode, restore database, and then put it back to multi user, it will fail. Has anyone run into this problem?

When I try to do this, it seems to restore the database but will be stuck in single user mode. I think this is because the alter database statement attempts before the restore is complete. Any thoughts or ideas?
philfry
0

Comments

1 comment

Sort by
  • petey
    Have you considered using the DISCONNECT_EXISTING option to disconnect all existing users to the database so that the restore can proceed? E.g.
    EXEC master..sqlbackup '-sql "RESTORE LOG AdventureWorks FROM DISK = [g:\backups\AdventureWorks_log_*.sqb] WITH STANDBY = [g:\standby\AdventureWorks.und], DISCONNECT_EXISTING"'
    petey
    0

Add comment

Please sign in to leave a comment.