June 5, 2006 at 4:14 pm
Hi
I have a sql2005 database split into filegroups ( 12) . On restoring a single filegroup the database locks in restore mode which will not unlock after the restore is complete ( log file states it is restored and the file size is correct )
There are no locks on the table and i have restarted SQL on the server in an attempt to bring the database on line again.
Arcserve Sql agent was used to backup and restore the filegroup with this being the second time of testing the restore
Any ideas how the unlock and prevent.
Any had this issue ?
June 5, 2006 at 4:34 pm
A couple of things if you are doing a filegroup restore I believe you have to back up tail of the log before starting the restore so that the filegroup being recovered can be recovered to a state consistent with the rest of the filegroups. Does arcserve do this for you?
The other possibilty is that arcserve just hasn't finished off the restore completelt and you just need to recover the database.
restore MyDatabase WITH RECOVERY
David
June 5, 2006 at 5:19 pm
Hi
Bit of background :
The whoel purpsose is to test the backup and recovery stratergy before we give the green light to the buiness to bulk load the data. My thoughts were to split the Db into 12 filegroups, total db size will be about 1.6 terra
Having taken a fullbackup have tested a full restore and all looks good. when i attempt a file group restore it locks after the restore is complete. I used file group restore and selected the one filegroup and forced restore over exsiting.
The restore was completed 3 days ago and has completed. We cannot gain access to the database at all as it is stuck in this restore loop. Every attempt we make we get an error back stating it is in restore mode.
We are now attempting the same thing but with SQL backup instead of arc server sql agent as the tool.
How do i recover the tail of the log.? ( restore and leave non operational then restore the log )
Thanks for your help !
June 6, 2006 at 12:20 am
To be honest the best thing to do is read the the bit in Books online about doing filegroup restores which explains what you need to do otherwise I'll just be regurgitating whats there as whats required will also depend on the recovery model and what version of sql server you are using.
To backup up the tail of the log you just do a backup log with no truncate.
hth
David
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply