|
|
|
Rank: Newbie
Groups: Registered
Joined: 11/20/2011
Posts: 3
|
I have an SQL Server 2005 database with an associated NDF file along with the MDF and LDF. How do I back up all files in a file group so that I can successfully restore later?
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 368
|
If you want the whole database - SBF will include ndf files just fine. However if you want just a certain filegroup - it is not supported. In other words in BACKUP DATABASE statement that SBF is using, it does not use FILEGROUP option.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 11/20/2011
Posts: 3
|
Did standard SBF backup. See attached word doc.
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 368
|
Can you restore to a new clean location? With NDF files the restore is a bit more complicated. This explains it well: http://www.mssqltips.com...s-for-high-availability/
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 11/20/2011
Posts: 3
|
I was restoring to a clean location. I will look through the information on the link supplied.
Thanks.
|
|
|
|
|
