I assume you are running the backup via QA. If so increase your connections "Login Timeout" setting under "Tools" - "Options" then click on the connections tab.

Gregory Larsen, DBA

If...

Try setting the connection string parameter "Connect Timeout"

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

When you say you reinstalled SQL Server, did you restore MASTER? Have you run "sp_change_users_login 'report'" on each database to see if there are any orphan users?

Gregory Larsen, DBA

If...

Hey, I like the suggestions. More heads are better than one.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.sqlserverexamples.com

If you are only moving specific tables then DTS will work nicely for you. Possible you could write an ActiveX DTS task to determine which binary files you need...

Some of those codes can be found in BOL by seaching for the following seach values including Quotes:

"Stored Procedures Data Columns"

and

"TSQL Data Columns"

and

"Scans Data Columns"

and

"Sessions Data Columns"

and...

What exactly do you want to sync up? Data only, or SP, and UDF's? All data, or only a subset of tables?

Gregory Larsen, DBA

If you looking for SQL...

SQL Server needs to maintain the transaction log to support transaction integrity, so you can just turn it off.

Basically you can set the recovery mode by database to simple, this...

Here is a solution to get XP_SENDMAIL to send a mail message longer than 8000 characters. It uses a global temp table to hold the body of the email....

You can try something like this:

select cast(1111.0860009 as decimal(38,2))

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

To read uncommitted reads in TSQL issue the following command:

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

then proceed with your SELECT statements. Your SELECT statement should be able to read...

Our SQL Server service accounts are domain accounts. We have does this so we can user NT file shares, send email using exchange, etc. Are accounts have either...

I think your right on how to track on migrate back. That's what I've done. But I'm not sure I would use your implementation Plan, and allow the customer...

Guess I had just a small trace file. It worked in both SQL 7 and 2000 for me. I appreciate the answer on why, and how you have...

Read up on the Database Integrity Check. Attempts to repair any minor problems will puts the database in single user mode.

So I'm guessing your maintenance plan says to...