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.
Showing posts with label acquire. Show all posts
Showing posts with label acquire. Show all posts
Subscribe to:
Posts (Atom)