December 18, 2009 at 12:09 pm
I have one .MDF file with size 500GB; I want to create Mulitle MDF files; I can create multile MDF files; But how to transfer the Data to the new DB; i. e how to restore? pls help.
December 18, 2009 at 12:15 pm
If MDF_2 is in the same file group then SQL will add to it outside of your control. If you create a secondary file group, then you can move tables or indexes to the new filegroup from the Primary file group.
It's beneficial if you have separate physical spindles so you can spread the data across more drives for better performance. For instance, put the data on one set of drives, and the indexes on another set.
December 18, 2009 at 12:26 pm
If the new file is in a separate filegroup, you move the data by moving the clustered index to the new filegroup.
Otherwise, it is as Homebrew said for if it is in the same filegroup.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 18, 2009 at 1:05 pm
thanks for your replies; But it did not help me.
I have a DB with one signle mdf file and one logfile (size 500GB). What is the procedures to have the db in myltiple data files and mutiple log files.
December 18, 2009 at 1:09 pm
This might be more along the lines of what you are requesting:
http://www.mssqltips.com/tip.asp?tip=1112
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 18, 2009 at 1:26 pm
thank you CirquedeSQLeil. This is what exactly I needed. Thanks for the link.
December 18, 2009 at 1:29 pm
NP.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply