July 7, 2009 at 12:24 pm
Is there a way to backup a database that is in standby mode? I know the simple answer is no. But is there a work around or solution. By detaching the db, taking the db offline and coping the file
We are using SQL 2005 standard edition sp 2.
What I want to do is test my warm server failover scenerio? I could start over with a fresh backup after the test but the database is 1.5 terabytes and the warm server is not local to the primary server.
It is interesting in what I can do. I can detach the db in standby mode but I can not reattach the database.
Dan Pitta
July 7, 2009 at 12:28 pm
what are you using to keep it warm, log shipping? transactional replication? DB Mirroring?
CEWII
July 7, 2009 at 2:34 pm
Yes, log shipping
Dan Pitta
July 7, 2009 at 3:17 pm
As far as I know, there is no supported way in that mode. You could shut down sql and copy the database files somewhere and then restart, it aint pretty but I think it would work..
CEWII
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply