We had to write a bat file to move the logs to an archive directory and append the date to the name.

As far as I know SQL Server 2000 didn't...

In my experience there is nothing wrong with using a hybrid method for reporting. Most often than not you will end up with a need for transactional reporting that...

Leo,

Did you try using detach/attach method instead of backup/restore?

thanks,

Olga

The SQL Agent is not running. 

I think I am getting the error because I don't have a windows authenticated sql account for the user I am looged in with.

I...

Thanks for the reply. Mohammed. 

The command worked but I can't login, the error message says only one administrator can login in a single user mode.  Any suggestions?

Thanks!

My question to Steve is Why did he repost a bad article with clearly misleading information.  I would take it off the server.

I don't think there is a way to do it in SQL Server.  We had to creat a batch file that moves the logs into a separate folder periodically, it...