Good to hear this. Please take a full backup of your database. Check that there is no error at IO level. Sharing your learning will be more helpful to others.

I am not sure about you OS. You can use the /F option with KILL command to make it forcefully kill the process. If you have TaskKill utility installed, you...

Did you try to kill the Backup process id manually? Kill the backup process ID forcefully and then run the full backup. Changing the database from Full to Simple will...

Please post the exact error message you are getting and the steps you followed.

Please let us know if you are able to restore your database.

In my best knowledge, you can't use this with SQL Server 2000.

DBCC DROPCLEANBUFFERS is used to test queries with a cold buffer cache without shutting down and restarting the server.

To drop clean buffers from the buffer pool, first use CHECKPOINT to...

Autogrowth in % is bit risky when the database is very large. Adding 10% of 1.5 TB database will take more time if keep the growth as 100 MB or...

Oops... mistake. Please go through

http://msdn.microsoft.com/en-us/library/ms190640(SQL.90).aspx

You can try to create a new shared folder and while Log Shipping configuration provide the full \\servername\saredfodler\

Ensure that the SQL Server...

You should read this article:

http://support.microsoft.com/kb/314515

You should check if the SQL Server Service is running fine, the SQL Agent Service is running and if you have installed/enabled other services as SQL Browsing, Reporting, SSIS, etc...

My suggestion for reconfiguring the mirror was based on db size of 200 MB and Log size of 2 GB which is not good sign. Even it was not stated...

In your kind of situation, you should backup the Transaction Logs more frequentyl, may be every 5 minutes.

The growth of log file may be normal due to usage of data...

Read this for more information on RAISERROR:

http://msdn.microsoft.com/en-us/library/ms178592(SQL.90).aspx

http://msdn.microsoft.com/en-us/library/ms178649(SQL.90).aspx

The very first thing you should do is add new file to Tempdb and location of file should be other disk drive.

You can try to shrink the tempdb files but...