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 |
|
gagan.707
Starting Member
9 Posts |
 Posted - 2008-01-20 : 02:53:04
|
| I am restoring a database from a backup file.but the MDF file formed is too large (100 GB)and the largest drive i have is of 60 GB.can I split this file among different drives.if yes how can i do that.following is the restore query i am using.exec xp_restore_database @database='DB1', @filename="E:\DB1.sls", @with='replace, move "DB1_data1" TO "H:\SqlData\DB1_data1.MDF", move "DB1_data2" TO "I:\SqlData\DB1_data2.NDF", move "DB1_log1" TO "E:\SqlData\DB1_Log1.LDF"' |
|
|
gagan.707
Starting Member
9 Posts |
Posted - 2008-01-20 : 02:54:59
|
| the file DB1_data1.MDF is 100 GBand too large fo my largest drive H: which is 60 GB.can i split this file to H: and E: ? |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-20 : 20:09:11
|
| No, find a big disk to fit it or shrink file in source db then backup again. |
|
|
|
ns_nataly
Starting Member
13 Posts |
Posted - 2008-01-21 : 06:17:26
|
| In the source DB split Data file in two : create new filegroup-> assign file ->move tables into new file (create clustered indexs ON NEWFILEGROUP) Backup and restore as files...Natalia |
|
|
|
|
|
|
Restore of database - can we split the MDF file