Registered users    
MembershipMembership:
Latest New UserLatest:Mary Reiman
New TodayNew Today:11
New YesterdayNew Yesterday:9
User CountOverall:23414
Private messaging    
You must be logged in to use this module.
Top 10 posters    
NamePosts
Mariette Knap12968
Marina Roos12627
Eriq Neale2117
Stan Guinn1917
Michael Patrick1914
Robert Pearman1791
Nick Pieters1425
william warren650
Stewart Brown620
Kevin D.579
Welcome unauthorized visitor    
If you want to join us in the discussions on this forum you need to register first. Registration is free! If you are already a registered user please login to join the forum.
Small Business Server Support Forum    
Forums > Microsoft Small Business Server 2003 & 2000 > SQL Server 2000
Subject: Backup
Prev Next
You are not authorized to post a reply.

Author Messages
Paul Janssen User is Offline
The Netherlands
Member since
5/25/2005

Registered Users
Posts: 63
8/15/2007 01:09 PM  
Just to be sure:

When I make sure that the SQL databases are in in simple recovery mode, I can use ntbackup to safely backup and restore the databases.

Is that correct?

PJ
Edwin Sarmiento User is Offline
Singapore
Member since
2/13/2007

Microsoft MVP
Posts: 133
8/17/2007 11:28 AM  
NTBackup may not backup open files properly. This is why we have VSS in Windows Server 2003 platform. Since MDF and LDF files in SQL Server are being used by the SQL Server service, running NTBackup may backup the database files but these files may be corrupted in the process even when there is VSS because it is freezing the database files. I'd recommend that you treat your databases differently by running SQL Server backups instead of NTBackup

I think this was the KB article you were referring to
http://support.microsoft.com/kb/903643
MCP MCDBA MCAD MCSD MCT MCTS MCITP : DBA MCSA
http://bassplayerdoc.blogspot.com
Need a remote SQL Server DBA?
You are not authorized to post a reply.
Forums > Microsoft Small Business Server 2003 & 2000 > SQL Server 2000 > Backup


ActiveForums 3.7
Forum policy    
These Discussion Forums are dedicated to the discussion of the Small Business Server and related server and client software. For the benefit of the community please observe the following posting guidelines:
  1. No Advertising. This includes promotion of commercial products and non-commercial products which are not directly related to Small Business Server and related server and client software.
  2. No Flaming or Trolling.
  3. No Profanity, Racism, or Prejudice.
  4. Site Moderators have the final word on approving/removing a thread or post or comment.
Copyright 2002-2008 Concentrix b.v.    :   Page generated in 0.2812518 seconds.   :   Terms Of Use   :   Privacy Statement