Re: Backup claims to have run, but there's no file
From: Maury Markowitz (MauryMarkowitz_at_discussions.microsoft.com)
Date: 10/19/04
- Next message: Mark Allison: "Re: LogShipping Between Named Instances"
- Previous message: Melih SARICA: "Re: cant get the correct num of rows from Oracle. in 2 SQL servers ( sql 7.0 and SQL 2000)"
- Maybe in reply to: Maury Markowitz: "Backup claims to have run, but there's no file"
- Next in thread: Tibor Karaszi: "Re: Backup claims to have run, but there's no file"
- Reply: Tibor Karaszi: "Re: Backup claims to have run, but there's no file"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 19 Oct 2004 06:51:06 -0700
"Greg D. Moore (Strider)" wrote:
> > Either way, still no backup file!
>
> I missed it, is this a full or transaction log backup?
Transaction log.
> If it's a transaction log backup either your database may be in SIMPLE
> recovery mode or a bulk insert has been done since the last full backup.
There is no "simple" in 7.0, but I have turned off the confusingly-named
options that seem to imply transaction logs should now work.
The only bulk work we do is SELECT INTO on #temp tables. If THAT is the
cause of the problem, I can't imagine why -- bulks into temp tables should be
ignored for the purpose of transaction logging.
And if that is the cause, what is the solution? Diff backups prior to trans
backups?
Maury
- Next message: Mark Allison: "Re: LogShipping Between Named Instances"
- Previous message: Melih SARICA: "Re: cant get the correct num of rows from Oracle. in 2 SQL servers ( sql 7.0 and SQL 2000)"
- Maybe in reply to: Maury Markowitz: "Backup claims to have run, but there's no file"
- Next in thread: Tibor Karaszi: "Re: Backup claims to have run, but there's no file"
- Reply: Tibor Karaszi: "Re: Backup claims to have run, but there's no file"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
