Build a script for CREATE DATABASE/FOR ATTACH

Question

Post reply

Build a script for CREATE DATABASE/FOR ATTACH

neiljacobson

SSCommitted

Points: 1717
More actions
September 24, 2007 at 4:03 am

#177409

Comments posted to this topic are about the item Build a script for CREATE DATABASE/FOR ATTACH

Viewing 3 posts - 1 through 3 (of 3 total)

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

Dan65807 SSC Enthusiast Points: 130 More actions · Answer 1

Thank you! looks like a great script. the 150gb database I am working with has 43 files. Hope it works.

Dan

Tom Pullen SSC Enthusiast Points: 130 More actions · Answer 2

Very handy script, saved me a lot of hassle when I realised joining from master.sys.databases to master.sys.master_files to generate this kind of script just wasn't going to be easy enough!!

Thank you!

Build a script for CREATE DATABASE/FOR ATTACH

Cookies on SQLServerCentral