Solved

Does ntbackup require sqlserverwriter to back up SQL 2005?

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
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.

805 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