Re: Timeout errors
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Wed, 17 May 2006 08:28:36 +0000 (UTC)
pb648174 (google@xxxxxxxxxxx) 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@xxxxxxxxxxxxx
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
.
- Follow-Ups:
- Re: Timeout errors
- From: pb648174
- Re: Timeout errors
- References:
- Re: Timeout errors
- From: pb648174
- Re: Timeout errors
- From: Erland Sommarskog
- Re: Timeout errors
- From: pb648174
- Re: Timeout errors
- Prev by Date: Re: purpose of OUTPUT keyword in sql server
- Next by Date: Re: T-SQL Debugger Doesn't Allow Stepping Through Stored Procedures no other procedure with the same name
- Previous by thread: Re: Timeout errors
- Next by thread: Re: Timeout errors
- Index(es):
Relevant Pages
|
