Attach database using sp_attach_single_file

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Attach database using...

Attach database using sp_attach_single_file_db

Rate Topic

Display Mode

Topic Options

Author

Message

Meet George Jetson

Posted Wednesday, February 20, 2013 2:17 PM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 7:51 AM
Points: 1,274, Visits: 1,204

Lets say I have an .mdf but no corresponding .ldf for a correctly detached database. Now I want to reattach it, but set the log file size and auto-growth rate at the onset.

While using the stored procedure sp_attach_single_file_db, I would like to specify the Initial Size as well as the AuAuto-growtho that I don't have to run a second script to Alter Database Modify File ...

Is there a way to combine the two into one? Or, should I be using the stored procedure sp_attach_db and in the @filename2 parameter add the SIZE = xxxx, FILEGROWTH = xxxx to the end somehow?

Any suggestions are always appreciated.

Chris Powell

George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.

Post #1422302

« Prev Topic | Next Topic »

Permissions