Backup Exec 10d

Posted on 2006-05-03
Last Modified: 2013-12-01
Hi Guys,

I have a customer which has a 1x Windows 2003 server and uses SQL server, but only one database and about 5 users using it.  Would I need the backup exec SQL agent as well has Backup Exec 10d for Windows server.

And is there a cheap why off backing up the server and the SQL database??


Question by:davidalley
    LVL 87

    Accepted Solution

    If you need to backup the database while it is online, you'd need the agent for sql server, yes. SQL also has some commands (you'd have to look for them as I don't know them) with which you can dump the database to backup files, and these you can just backup because once the dump is done the files aren't open anymore. In the case of a disaster you'd have to import these files back into the database. It is advisable that you use such dumps in anycase, and to another HD than where your database resides on. You can run these dumps in short intervalls which would ensure that in case of the database going corrupt you'd have a better chance of restoring all your data.
    LVL 26

    Assisted Solution

    by:Leon Fester
    In SQL, you can create a maintenance plan that includes backing up of the database. You are then able to restore the database using these backups.

    Once you've got a backup of your SQL database, then use NTbackup and include the folder locations where your SQL maintenance plan has saved the backups.

    In the above scenario you would not need to use SQL server agent.

    P.S. Bearing in mind that most W2K3 server have shadow copy installed it is recommended that you not include the location of the actual files being used in the database. These files will also be included in your backup. Although it is not recommended that your actual database files are included in the NTbackups.
    LVL 95

    Expert Comment

    by:Lee W, MVP
    You can always use a trick - if your databases can spare a little downtime - setup a pre and post backup script (command really) - the pre:


    The post backup:


    This will STOP the SQL Server service, allowing the backup software to backup the file like any other, then start the SQL service after the backup has begun.

    In the case of a restore, you would have to detach the existing database and then attach the restored backup files (LOG (LDF) AND MDF).

    Though honestly, I'd probably do the SQL based backup to a file otherwise.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    I previously wrote an article addressing the use of UBCD4WIN and SARDU. All are great, but I have always been an advocate of SARDU. Recently it was suggested that I go back and take a look at Easy2Boot in comparison.
    How to update Firmware and Bios in Dell Equalogic PS6000 Arrays and Hard Disks firmware update.
    The viewer will learn how to count occurrences of each item in an array.
    The viewer will learn the benefit of using external CSS files and the relationship between class and ID selectors. Create your external css file by saving it as style.css then set up your style tags: (CODE) Reference the nav tag and set your prop…

    779 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

    16 Experts available now in Live!

    Get 1:1 Help Now