How to backup MS SQL 2005 databases using ntbackup

Posted on 2009-02-10
Last Modified: 2012-09-04
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.

Question by:imgadmin
    LVL 5

    Expert Comment

    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 ( free)

    Author Comment

    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...
    LVL 57

    Accepted Solution

    Yes you can.. Please find more detailed information about it below:

    Complete details and steps are mentioned over here..

    Author Closing Comment

    Thanks for response. I will start with deploying new backup infrastructure and will use sql backup agent.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    How to update Firmware and Bios in Dell Equalogic PS6000 Arrays and Hard Disks firmware update.
    Learn about cloud computing and its benefits for small business owners.
    This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
    The viewer will learn how to download, install and use CrashPlan from on Windows 7. Open your browser and go to Click get started, it’s free then Click the Download CrashPlan button: Click save in Internet Explorer, the…

    760 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

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now