Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Does ntbackup require sqlserverwriter to back up SQL 2005?

Posted on 2008-10-14
4
Medium Priority
?
452 Views
Last Modified: 2012-06-27
Hi,
   from reading this doc: http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlwriter.mspx
my understanding is that the SQL writer service is intended to allow third party apps to utilise VSS. Is this correct? What I need to know is whether or not ntbackup needs the SQLwriterservice to back up SQL 2005.

thanks!
0
Comment
Question by:hannibalsmith
  • 2
  • 2
4 Comments
 
LVL 32

Expert Comment

by:Daniel Wilson
ID: 22711268
The recommended method for backing up SQL Server DB's will still be to have SQL Server do its own backup (probably to another disk on the same machine), then have NTBackup or other general-purpose backup software back up the resulting .BAK files to an external medium.

As far as I know, NTBackup doesn't do anything with SQLWriter -- but I can't say for sure.
0
 
LVL 1

Author Comment

by:hannibalsmith
ID: 22711775
Thanks Daniel. Ok, I understand you're not 100% on whether or not ntbackup uses the sqlserver writer, but we could look at this another way.

The end user is using ntbackup to back up .bak files- that much I'm sure of. If that is the case, would ANY SQL writer (or MSDE writer) be needed to backup the actual .bak file?

thanks
0
 
LVL 32

Accepted Solution

by:
Daniel Wilson earned 750 total points
ID: 22711821
No, I don't think the SQL Writer would be needed in that situation.

SQL Agent does need to be running to schedule those backups to the .BAK files ... I guess it's possible that IT uses SQL Writer ... but if the .BAK's are being generated reliably, I wouldn't look any further.

The .BAK file is just a file -- it's not locked down (except during a backup or restore) for the express purpose of being able to be backed up further.
0
 
LVL 1

Author Comment

by:hannibalsmith
ID: 22712359
ok, that's good enough for me. Thanks Daniel!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

877 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question