Try compression.

1) Yes, It is feasible to do database mirroring on a 2 GB database.

2) If you don't have physical severs for testing, try Virtual Servers in a PC.

Method 2 (backup to same folder) is better as it is easy to manage.

Check the size of the data file and log file.

Recovery model should be SIMPLE.

Are you able to login to the SQL Server on the other machine?

Have you tried to restore the database from the backup? What error message did you get?

Is the .BAK...

Generate script to create these tables. It would take care of the indexes, constraints, etc.

Then use the export wizard to export only the data.

Both versions reported report success does not mean they executed the DROP TABLE part. IF condition returned...

Database compitability of SQL Server 2000 model database is 80. In SQL Server 2005 it is 90. Because the database structure is different. So you should not have copied the...

I have not added a processor to a server running a SQL Server instance. However I would like to share this information:

MSDE supports 2 processors. In SQL Server 2005 it...

1) Check the data and log file size.

2) Check whether the AutoGrowth is ON for database and log files?

3) Check the free disk space.

4) Check whether there is any open...

Distributor's service account and password.

DBCC SQLPERF() provides transaction log space usage statistics for all databases (BOL).

The "unallocated space" returned by SP_SPACEUSED is "space in the database that has not been reserved for database objects...

I think sp_tempdbspace is a user created stored procedure. I could not find it.

It is possible to ignore that row with parameter -SkipErrors 20598

There might be a database maintenance job such as index rebuild.