Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 ndf file in restoring mode, backup failed.

Author  Topic 

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2011-10-11 : 16:05:53
Hi,

I am taking backup of one database. SQL server 2005. Backup failed with following error: File ...... is offline. I ran select * from sys.database_files. It shows one of ndf file in restoring mode. Other files are online. How to bring this ndf file online? Any help will be appreciated.

Thanks

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-10-11 : 16:46:00
First step will be find out why the ndf is restoring. Someone must have run a restore recently, that file will have been unavailable since then.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2011-10-11 : 16:49:26
I refreshed from prod to dev. Restore was successful. Database is accessable but cannot take backup, one file showing in restoring mode.
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-10-11 : 17:02:31
Then your restore did not finish completely and correctly. What was the restore command and what is the database structure (in terms of files). Any messages in the error log from the time of the restore.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2011-10-11 : 18:03:29
I ran dbcc checkdb. it shows filegroup secondary offline. Is there any way to bring filegorup online or drop this filegorup?
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-10-12 : 02:53:02
quote:
Originally posted by GilaMonster

What was the restore command and what is the database structure (in terms of files). Any messages in the error log from the time of the restore?


--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -