But does SQL Server change the size of the virtual logs? If I have a 650Mb log file consisting of 2 325Mb virtual logs, and the log grows beyond...

I can confirm that the detach/re-attach method works. I detached the database in Enterprise Manager (EM), renamed the logfile, then re-attached the just the MDF using the SP in...

Thanks for all the responses.

I found the loginfo command but I didn't really understand the info it returned. I worked out there were two virtual logs because it returned...

DBA skills aren't my area either as you can probably tell by the mistake I made with the log files in the first place!

I'll check that chapter out in more...

Thanks for the reply. I set up another database to test this out on. The database is approx 20Gb and I left SQL Server to create a log...