December 1, 2003 at 10:18 am
*** PLEASE HELP ***
I detached a database becuase the log file to clear a full log file (know that this is not the best way to do this). Have done before with no problems. I delete the logfile, then reattach and a new logfile is created.
This time an error message flashd up to say that the logfile was full. Have tried to reattched the database. As usual prompts to say that it will create a new logfile but then says 'ERROR 1813:Could not open new database. Device activate error. The physical file name e:/sqldata/mssql/data/logfilename.ldf does not exits'
If any one has any ideas please let me know asap
December 1, 2003 at 11:51 am
To clear the log file, you need to run a "backup transaction dbname with no_log", not delete it. Can you restore the file? (ldf)
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 2, 2003 at 7:08 am
Steve - Thanks for the reply.
I have managed to get a copy of mdf and ldf file restored from a backup tape.
Could you point me to any articles about the best way of clearing down the logfile?
December 2, 2003 at 8:44 am
BOL: backup and restore
December 3, 2003 at 9:47 am
Anytime, glad it worked.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply