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 |
|
AgaK
Yak Posting Veteran
86 Posts |
 Posted - 2010-05-18 : 17:35:52
|
| HiWe are implementing a new application. I got a backup with empty tables from the vendor. I would like to create 3 additional primary data files to improve the performance. Will adding the 3 PRIMARY file to the database once I restore automatically spread data among the 4 primary data files? The empty tables were created when the database had only one primary datafile.Any links to articles about a similar situation would be awsone.Thank youAK |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2010-05-19 : 06:08:14
|
| what will be the expected data per day?ArnavEven you learn 1%, Learn it with 100% confidence. |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-05-19 : 09:16:14
|
| No. Restore recreates the database exactly as it was at the point of backup, so if the backup was taken when the DB had one file, once the backup is restored, the restored database will have only one file.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
additional primary data files