How about backup across servers? If the size of this database is huge, you may consider the third party tool, such as LiteSpeed.

Did you have chances to read these discussions?

http://sql-server-performance.com/Community/forums/t/5633.aspx

http://www.webservertalk.com/archive132-2006-4-1485172.html

I believe that you need to test your ODBC connection. It may only work for your system admin account.

Also, regarding the log,

SQL Server is terminating due to 'stop' request from...

You may reboot your machine to remove related registries and try again.

Actually, you can use the command,

BACKUP LOG databaseName WITH TRUNCATE_ONLY

before detaching it.

Or after detaching it, do not include log file wihile re-attaching it. Let the system to create a...

You will get an error when you would like to insert more data. Also, you will see an error in your SQL log.

In the Properties of SQL instance, you can set the maximum memory under the memory tab.

Two suggestions.

1. Check you mail server and email address

2. Add a log file in your DTS package to obtain error in detail.

Hi, folks!

This is a forum to discuss the topics we are all interested. It is not a battle field. My understanding is that Jeff was kidding (from the icon he...

In my memory, we need to select which instance(s) we would like to apply either service pack or hot fix if there is more than one instance on a cluster....

How about something like the following:

SELECT (SELECT COUNT(*) FROM Customers) AS totalCount, * FROM Customers

😉

Generally speaking, you had better restore the database if you have the latest backups.

If your mdf is healthy but ldf is crashed, you can attach the mdf file only and...

You may change your transaction isolation level or add NO_LOCK clause in your queries.

Here is my penny.

The shortcut is to ask someone to show its entrance, such as how to do something basic. Then, practice.

Here is a link for the same error while installing SQL 2005. Hopefully, it helps.

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