Re: ntbackup & MS SQL 2k SP3 on Server 2003
From: Brian Bergin (ntbugtraq.1_at_TERABYTE.NET)
Date: 09/18/03
- Previous message: Tony: "DNS Hijacking: The largest single breach of privacy and security thus far online..."
- In reply to: Harald Ums: "Re: ntbackup & MS SQL 2k SP3 on Server 2003"
- Next in thread: Susan Bradley, CPA aka Ebitz - SBS Rocks [MVP]: "SUS changes - the word from Microsoft as posted into the SUS newsgroup..."
- Reply: Susan Bradley, CPA aka Ebitz - SBS Rocks [MVP]: "SUS changes - the word from Microsoft as posted into the SUS newsgroup..."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 18 Sep 2003 09:48:21 -0400 To: NTBUGTRAQ@LISTSERV.NTBUGTRAQ.COM
At 17:38 04 09 03 Thursday, Harald Ums wrote:
>----- Original Message -----
>From: "Brian Bergin" <ntbugtraq.1@TERABYTE.NET>
>To: <NTBUGTRAQ@LISTSERV.NTBUGTRAQ.COM>
>Sent: Wednesday, September 03, 2003 11:39 PM
>Subject: ntbackup & MS SQL 2k SP3 on Server 2003
>
>
> >
>I have some difficulties to understand the whole thing.
>The reproduce the problem I ran ntbackup.
>
>The eventlog showed an errorid=6004 Source=VSS with a text: Sqllib error:
>Database demo is not simple.
>
>So I think it should have been possible to track down to problem to the
>SQL database within a finite time.
>
>Further tests showed that the error only appears when backing up from a
>volume on which there a database files of a database in Full Recovery
>mode. Backing up all other volumes showed no error at all.
>So it is not a problem if SQL Server is installed and running - you simply
>cannot backup databases in Full Recovery mode using a file backup.
>
>It looks as if database recovery has problems with vss or does not trust
>vss to backup the database correctly. So I guess the database people are
>returning the error to vss.
>
>I do not see any good reason to back up the database when using Full
>Recovery mode with a file system backup, I would always use the database
>backup tool.
>So if you separate database files from all other files, you do not have
>any problem.
I'm not trying to backup the db's with Shadow Copy, I want the rest of the
system backed up with Shadow Copy. We have never attempted to backup the
db's. The bug continues even if you deselect the db's and the SQL
installation folder. Again, I must restate, even if you DEselect the sql
db's and the sql installation folder Shadow Copy fails. Period. MS has
confirmed this is a bug and they are going to fix it, though not to include
Shadow Copy of SQL db's, which we already backup several times/day with
bull Full Backups and Trans logs to a NAS system.
NOTE: Please reply to the list so others may benefit from your
thoughts. If you're concerned it may not make it to the list, please cc:
me on the reply.
Sincerely,
Terabyte Computers, Inc.
Brian S. Bergin
President
---- Are You "Certifiable"? Summer's Hottest Certification Just Got HOTTER! With a growth rate exceeding 110%, the TICSA security practitioner certification is one of the hottest IT credentials available. And now, for a limited time, you can save 33% off of the TICSA certification exam! To learn more about the TICSA certification, and to register as a TICSA candidate online, just go to http://www.trusecure.com/offer/s0100/ ----
- Previous message: Tony: "DNS Hijacking: The largest single breach of privacy and security thus far online..."
- In reply to: Harald Ums: "Re: ntbackup & MS SQL 2k SP3 on Server 2003"
- Next in thread: Susan Bradley, CPA aka Ebitz - SBS Rocks [MVP]: "SUS changes - the word from Microsoft as posted into the SUS newsgroup..."
- Reply: Susan Bradley, CPA aka Ebitz - SBS Rocks [MVP]: "SUS changes - the word from Microsoft as posted into the SUS newsgroup..."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
