[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1935
  • Last Modified:

How to backup MS SQL 2005 databases using ntbackup

Dear Gurus,

Is is possible to backup MS Windows 2003 operating system with MS SQL 2005 databases using NTBackup tool without losing consistency of SQL databases? Is starting SQL Writer service (to make use of VSS feature) on a database server enough to perform this or there is something more to be done? Or maybe it is not recommended to perform SQL databases backup this way and the most reliable way is to backup databases to some share using Maintenance Plan?

Thanks a lot in advance for advices.

Regards,
Konrad
0
imgadmin
Asked:
imgadmin
  • 2
1 Solution
 
funnymanmikeCommented:
first create a backup in sql

Run SQL Server Enterprise Manager
Drill down and find Database Maintenance Plans
Right click to create a new Maintenance Plan
Follow the wizard, it will guide you. just answer the questions its asking

then NT backup can backup the sql backup file if you wish

but you should realy look into drive imaging (http://clonezilla.org/ free)
0
 
imgadminAuthor Commented:
funnymanmike, thank you for response. I know this solution. It requires to backup SQL databases to bak files stored on some share + backup filesystem and above bak files to some backup media. I would prefer to use vss functionality and backup filesystem + databases with one shot using NTBackup but I'm not sure if it is possible...
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Yes you can.. Please find more detailed information about it below:

http://technet.microsoft.com/hi-in/library/cc966520(en-us).aspx

Complete details and steps are mentioned over here..
0
 
imgadminAuthor Commented:
Thanks for response. I will start with deploying new backup infrastructure and will use sql backup agent.
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now