Solved

Does ntbackup require sqlserverwriter to back up SQL 2005?

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
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.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

746 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

13 Experts available now in Live!

Get 1:1 Help Now