SQL Server Database Restore on NAS

  • 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.......

  • 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

  • AK1516 (10/1/2011)


    AND THE QUERY WINDOWS SAYS

    EXECUTING.......

    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.

  • 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:

    http://support.microsoft.com/kb/304261

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply