What are the challenges you face when working across database platforms? Take the survey
Options

Restoring Database with Ext Stored Proc

philfryphilfry Posts: 2
edited June 4, 2012 10:29AM in SQL Backup Previous Versions
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?

Comments

  • Options
    peteypetey Posts: 2,358 New member
    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"'
    
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.