July 9, 2004 at 3:14 am
Hello Guys...have a big problem here... about attaching database.
i have one database with 4 log files.once i detach my database i can no longer attach anymore i think because of 4 log files the Ok button is disabled. how can i solve this one... HELP PLS....
Thanks In Advance ....
ZEROCOOL
heres my email: gspagdilao@hotmail.com
DROP THE ZERO AND GIVE IT TO THE HERO...ZEROCOOL
July 9, 2004 at 10:46 pm
Use the sp_attach_db stored procedure instead of trying to do it through Enterprise Manager. You can fin information about it in Books Online.
sp_attach_db @dbname = 'whatever',@filename1 = 'what.mdf', @filename2 = 'what1.ldf', @filename3 = 'what2.ldf'
etc. etc. etc.
Derrick Leggett
Mean Old DBA
When life gives you a lemon, fire the DBA.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply