How to split one mdf file into two

Question

How to split one mdf file into two

Viewing 3 posts - 31 through 32 (of 32 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004448 More actions · Answer 1

DKG (4/30/2009)
Of couse this is not a good practive to take backup on DVDs

I'd say the jury is still out on that one for smaller systems. With compression, you can save over 30GB on one writable DVD and there's no chance of stretching a tape with DVD's. 😛

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

SandyKools SSC Journeyman Points: 79 More actions · Answer 2

http://blogs.msdn.com/b/kronos/archive/2010/04/26/splitting-your-database-files-by-using-sql-server-management-studio.aspx

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 3

Sandeep... since you are new here (first post it seems): 1) WELCOME to sqlservercentral.com 2) PLEASE look at the dates of the threads before you post to them. This one is almost 2 YEARS old. There is never a need to post to such an old thread, especially one that was well covered and answered 3) speaking of well answered, there is also no need to post a solution that has already been covered.

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service