This came up today and I didn't know exactly how to properly do it.<BR><BR>The situation: We were to move a database from a MS SQL 2000 server into our in house MS SQL server and run the restore to ...

The transaction log file contains the SQL Server transactions of the database. It basically records the database transactions and the changes made by the transactions to the database. The logs are ...

There could be many reasons why you need to restore a database. Let’s look at some common reasons. The server has been re-installed, after failure. The database gets corrupted or is not mounting.

I have a SQL Server 2000 database and I need to put a functional copy of it on a laptop. I planned on doing a simple backup/restore to get it over there but I'm running into problems. <BR><BR>1st of ...