January 30, 2002 at 12:40 pm
Our earlier SQL Servers ran under NT. We used a C partition of about 2GB with the rest of the disk being drive D.
New directive: our new boxes with Win 2000 will only have a single, large, C partititon. Any ideas what's the best way to restore our old DBs (that resided on D) to this new partition scheme? I'm worried about embedded paths in the DB info, DTS scripts....
Bill
February 2, 2002 at 7:29 pm
Sounds like fun. Maybe a little trickery via the Subst command in the OS?
Andy
February 4, 2002 at 9:57 am
What version of sql? If 7 or 2000, you can attach the databases and move them at the same time with the WITH MOVE option.
Steve Jones
February 5, 2002 at 1:36 pm
And if this is coming from a backup set then you just start SQL server and create the databases then in EM you can restore directly over them to their current position, no questions asked. We have done in the past done restores to duplications on the same box (say original is Test we create a db Test2 and restores Test to Test2).
February 5, 2002 at 2:09 pm
Bill,
When you say embedded paths, were paths hard-coded into stored procedures and/or DTS ActiveX Task Steps?
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply