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 |
|
potinenir
Starting Member
19 Posts |
 Posted - 2003-07-11 : 14:20:29
|
| How can i restore a database (single datafile with size of 70gig) into another database and spreading it out onto multiple datafiles?For example my database has single datafile with size 70 gig.I took a backup of the database. The size of the backup is 70 gig.Now due to performance reasons i want to recreate the database with multiple 2gig files spreading over different filesystems. Now i want to restore the database with the existing backup(single datafile 70 gig--backup file 70 gig) file and spread out the data in new database.IS IT POSSIBLE TO DO THIS OR THE ONLY OPTION IS EXPORT IMPORT??Thanks,raj |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-11 : 14:24:28
|
| You need to first restore the database using one file. Then you need to setup filegroups. Then you need to move some tables onto those filegroups. The way that you have it right now is that you have an MDF with every table on that file. You need to create NDF files and move tables onto that.Tara |
 |
|
|
potinenir
Starting Member
19 Posts |
Posted - 2003-07-11 : 14:28:25
|
| Thank you Tara for the prompt reply |
|
|
|
|
|
|
restore of a database