Home > IT Answers > Storage > SQL 2005 Restore DB with Multiple files in Pr...
Help

Question

  Asked: Nov 6 2007   8:58 PM GMT
  Asked by: Leeland

SQL 2005 Restore DB with Multiple files in Primary File group


Restore, Database, SQL, SQL Server, SQL Server 2005

Is it possible to take a backup of a database that has multiple files within the primary file group (10 total in this example)

and restore that backup to a new database that has only one file in the primary file group?

THanks,

Lee

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Dec 2 2007  11:08 AM GMT  by Mrdenny




No. The restored database will have the same number of files as the database had when it was backed up. In addition the files will be the same size.

If you wish to reduce the file count you will need to do this after the database has been restored.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Storage, Database and Development.

Looking for relevant Storage Whitepapers? Visit the SearchStorage.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register