Thursday, March 8, 2012

Database restore questions

Hello Gurus,

I wanted to restore a database to multiple data files from backup which has got only few data files. Is it possible do this?

Example : Backup has 4 data files and I need to restore it to 8 data files.

Thanks

Subbu

No. A restore is a 1 for 1 operation. After you are done restoring, you can then add more files/filegroups and move data around if you want to.

No comments:

Post a Comment