October 6, 2010 at 3:46 pm
Here's the problem I've inherited. Two drives D: and E:
D: was created to hold only the logfiles and E: was created to hold the data.
When the database was created the files were created incorrectly. The logs created on E and the datafile created on D. Then someone created a SECOND logfile on D: and a SECOND PRIMARY datafile on E:
I've made backups of the logfiles and database and tried to shrinkfile the incorrect logfile to EMPTYFILE but it never goes quite down to 0, ergo I can't delete it. I can live with the two logfiles for now but how do I get the datafile on D merged into the datafile on E and then dropped from D?
Don
October 6, 2010 at 3:51 pm
Please refer to http://www.sqlservercentral.com/Forums/Topic458542-148-1.aspx
---------------------------------------------------------------------------------------
It begins by taking the first step.
October 6, 2010 at 4:01 pm
Perfect, I'll give it a try!
Thanks!
Don
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply