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.
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 ShawSQL Server MVP |
|
|
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. |
|
|
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 ShawSQL Server MVP |
|
|
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? |
|
|
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 ShawSQL Server MVP |
|
|
|
|
|