October 1, 2011 at 4:34 pm
We have a new test environment where we need to restore the SQL Server Database 2008 which is on Windows Server 2008 R2. We have our nt admin iscied the NAS drive to box which looks likes a mapped drive unlike SAN.
I have added the share using xp_cmdshell for the SQL to pickup and then enabled the trace 1807 and restored the database. The results windows says the restore done 100% and successfully read all mdf ,ndf and ldf FILES .... BUT THE DATABASE IS IN STILL RECOVEY MODE AND THE QUERY WINDOWS SAYS
EXECUTING.......
October 2, 2011 at 6:43 am
Then the restore is not complete. It's still rolling forward or rolling back transactions to finish up. That, or your backup processes had NORECOVERY set, in which you case you have to finish the process by running RESTORE WITH RECOVERY
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 6, 2011 at 12:38 am
AK1516 (10/1/2011)
AND THE QUERY WINDOWS SAYSEXECUTING.......
At times, it takes more time to roll back/roll forward transactions copied from the log file in the backup file. It'll finish on it's own in sometime.
October 7, 2011 at 12:25 pm
Hmmm. SQL Server doesn't support hosting the database files on Networked Attached Storage (NAS) as opposed to a SAN.
You can do it, but you might get some flaky errors. I was researching something similar at work.
Here's the Knowledge Base article:
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply