Hello fellow SQL Server users :-)
Some background. Have a database (quite large) that has
diskspace problems. Need to acquire more space so that the
database wont experiance some future problems. So to
remedy this problem temporarily i created a new logfile on
another disk. I also shrunk and restricted the filegrowth
on the first logfile. Ok, the problem was solved for the
time being.
Now we have scheduled a stop in the SQL Server (it's
version 7.0 and latest SP) so now i am doing a detach of
the database to move it all to new disks.
I am attaching the mdf file on one disk and the logfiles
on another disk.
The thing is. I just want one logfile and not two logfiles
on the new disk. How can i get rid of the new logfile (or
old one, doesnt matter which) so that i get the sweet
feeling of one MDF and one LDF file on the disks?
I know that when only having one ldf file you can use
sp_attach_single_file_db to attach the database and it
creates a new logfile for you. But that doesnt work when
having 2 logfiles from the beginning.
It isn't absolutly necessary but it looks a lot better...
So if you have a way to solve this please post it here
Thanks in advance
Risunsee dbcc shrinkfile emptyfile.
You can then use alter database to drop te file.
No comments:
Post a Comment