Solved

Does ntbackup require sqlserverwriter to back up SQL 2005?

Posted on 2008-10-14
4
446 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL: Transformation or Pivot 3 37
Enable TLS 1.2 for SQL 2012 Web Edition 1 25
relocating SQL 2000 18 39
MS SQL TO JSON 14 18
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

710 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