Posted by Erland Sommarskog on 05/17/06 11:28

pb648174 (google@webpaul.net) writes:
> All three each time - it backs up prod1, then prod 2 and restores it to
> backup. So it is alternatively taking errors on all three machines
> while connecting, but this only happens once or twice per month.

That's impossible! I mean in the original post of this thread, you said

The code in the sql is as follows:

BACKUP Database DBName to DISK='D:\Files\Backups\DBName.bak'
WITH INIT

That's one backup statement, not two, and not a RESTORE statement in sight.

What about telling the full story of what's in the script?


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: T-SQL Debugger Doesn't Allow Stepping Through Stored Procedures no other procedure with the same name
• Prev in forum: Re: purpose of OUTPUT keyword in sql server
• Thread view: Re: Timeout errors

[Reply to this message]