Disabling NT Backup using VSS on MS SQL 2000 databases
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
Hi,
I have a Window 2003 server with MS SQL Server 2000 SP4. I have setup
SQL Database Maintenance Plans to backup the databases. The issue is
that we do incremental and full backups with NT backup. NT backup is
creating incremental and full backups of the database/databases dispite
the fact we have configured the NT backup to not backup the folder that
contains SQL Databases and .MDF & .LDF file extensions.
I suspect the reason is the fact that the server has been figured with
the one volume C: drive. (I know it is not ideal configuration, but I
did not setup the server.) Thus when we a using NT backup to backup
system state it using VSS by default on the whole volume and calling
MSDEWriter to create a snapshot copy of the database (either
incremental or full).
Thus my question is there a way to disable NT backup from trying to
backup SQL Server.
Lui.
.
Relevant Pages
- RE: ESENT Logging
... SBS server 2003 has a backup job that will ... 145881 How to Use Jetpack.exe to Compact a WINS or DHCP Database ... Microsoft CSS Online Newsgroup Support ... (microsoft.public.windows.server.sbs) - RE: Backups have Shadow Copy Problems
... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ... (microsoft.public.windows.server.sbs) - Re: Copying a database between servers
... In 2000 you can backup to an UNC path ... or a local drive and the same goes for the restore. ... backup the database and then restore it on the new server. ... >>> one SQL Server 7.0 database with 'select' access to another SQL ... (microsoft.public.sqlserver.tools) - RE: Adventures in Server restore
... SP1 for exchange change the db jet and should fix this problem ... > I thought I'd pass on my experience in bringing back an exchange server ... I'm not sure what happened (but a online backup was going on) ... > persists then please restore the database from a previous backup. ... (microsoft.public.exchange.admin) - RE: How do I restore from mdf and ldf files?
... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ... (microsoft.public.sharepoint.portalserver) |
|