|
|
|
SSC-Enthusiastic
 
Group: General Forum Members
Last Login: Tuesday, November 03, 2009 12:23 PM
Points: 123,
Visits: 172
|
|
|
|
|
|
SSChasing Mays
Group: General Forum Members
Last Login: Yesterday @ 2:48 PM
Points: 646,
Visits: 1,267
|
|
Good work. This puts it all together. Much better than the detach / move files / attach process that I've been using.
ATB
Charles Kincaid
|
|
|
|
|
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, November 03, 2009 12:23 PM
Points: 123,
Visits: 172
|
|
| Thanks, this process can be used to many others uses, a cp files can be however, not many dba's like to have cmd other than sqlcmd runing on theirs boxes
|
|
|
|
|
SSCommitted
Group: General Forum Members
Last Login: Today @ 4:34 PM
Points: 1,957,
Visits: 4,265
|
|
| ......and if doing this type of process good to do a backup just before just in case..............:)
|
|
|
|
|
Grasshopper
Group: General Forum Members
Last Login: Thursday, September 03, 2009 2:34 PM
Points: 15,
Visits: 35
|
|
Just to be sure this is the best way to go about achieving what I need to accomplish; here's the scenario.
Today, I need to free up space on existing drives to make room for a ton of data that will be added this evening. It seems to me the best way to do this is to move a filegroup from Drive D [which has the least amount of space and will grow the most] to Drive F [the new empty drive]. Will your procedure work for this particular situation? Is there a better way [easier way] to do this? I am always amazed that you can't redirect to a new physical drive just as you do when you create a new filegroup but of course, that would be too easy. Thanks for input.
|
|
|
|
|
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, November 03, 2009 12:23 PM
Points: 123,
Visits: 172
|
|
| Yes, it will work, however, before trying this is always good to create a backup of your database; also, it doesn't hurt to set the database to single_user and run the script within the same session.
|
|
|
|
|
Grasshopper
Group: General Forum Members
Last Login: Thursday, September 03, 2009 2:34 PM
Points: 15,
Visits: 35
|
|
Dude, you rock! The last time I did that it was an incredibly painful process; detach database; move everything over; redirect and redo indexes; double check permissions; reattach database. This was way more efficient and from the looks of things, everything worked without intervention - no recreating logins and permissions, no redirecting in code. Awesome! I am a happy person. 
|
|
|
|
