Solved

Does ntbackup require sqlserverwriter to back up SQL 2005?

Posted on 2008-10-14
4
441 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 250 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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

932 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now