+ Post New Thread
Results 1 to 6 of 6
Windows Thread, [ANSWERED] Can I use NTBackup to backup MSSQL 2005 databases? in Technical; Hey guys, I'm using Microsoft SQL Server 2005 Express edition. As anyone here who manages these servers knows, it's not ...
  1. #1
    link470's Avatar
    Join Date
    Nov 2007
    Location
    Canada
    Posts
    250
    Thank Post
    85
    Thanked 8 Times in 6 Posts
    Rep Power
    15

    [ANSWERED] Can I use NTBackup to backup MSSQL 2005 databases?

    Hey guys,

    I'm using Microsoft SQL Server 2005 Express edition. As anyone here who manages these servers knows, it's not very easy to configure a backup from these servers as there's no Maintenance plans available [someone please correct me if I'm wrong, obviously]. But I'm wondering, would it be safe to backup these databases by simply backing up the %PROGRAMFILES%\Microsoft SQL Server\MSSQL.1 folder containing the Data folder [where it appears the databases are kept]? Since NTBackup uses shadow copies I don't think I'd need to stop the service. I can if neccessary via a script that runs just before the backup does, and then restart it afterwords with another script [or script a stop service>backup>start service all in one script]. But back to the main point Would this work? I've transferred databases from that folder before to another server and had it work perfectly fine.

    Thanks!
    Last edited by link470; 19th August 2011 at 10:45 PM.

  2. #2

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,652
    Thank Post
    516
    Thanked 2,443 Times in 1,891 Posts
    Blog Entries
    24
    Rep Power
    831
    It wouldn't back up the LDF or MDF files without stopping the service - what is a better idea is scripting MSSQL to run a backup routine before your NTBackup runs and then backup the resulting .bak files instead.

    You really should run the internal backup routines in MSSQL in order to truncate your LDF files, else they'll grow bigger and bigger.

    At least, that's my take on it from my experiences.

  3. Thanks to localzuk from:

    link470 (19th August 2011)

  4. #3
    link470's Avatar
    Join Date
    Nov 2007
    Location
    Canada
    Posts
    250
    Thank Post
    85
    Thanked 8 Times in 6 Posts
    Rep Power
    15
    Thanks for your reply localzuk, do you know how I can do this in Microsoft SQL 2005 Express Management Studio? I've never found a good way to schedule almost anything. If you have an example of a script and how I can schedule it, that would be greatly appreciated!

    Thanks again.

  5. #4

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,652
    Thank Post
    516
    Thanked 2,443 Times in 1,891 Posts
    Blog Entries
    24
    Rep Power
    831
    I don't backup using scripts any more - its all done using BackupAssist, however you can do it via a Windows scheduled task, and an sql script

    eg.
    "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\SQLCMD.EXE" -i"c:\path\to\sqlbackupScript.sql" as the command and there's a simple backup script here -
    Simple script to backup all SQL Server databases

  6. 2 Thanks to localzuk:

    elsiegee40 (20th August 2011), link470 (19th August 2011)

  7. #5
    link470's Avatar
    Join Date
    Nov 2007
    Location
    Canada
    Posts
    250
    Thank Post
    85
    Thanked 8 Times in 6 Posts
    Rep Power
    15
    I'll give that a try! Thanks a lot.

    ::EDIT::

    This method appears to work great. Thanks again!
    Last edited by link470; 20th August 2011 at 01:53 AM.

  8. #6

    elsiegee40's Avatar
    Join Date
    Jan 2007
    Location
    Kent
    Posts
    10,709
    Thank Post
    1,784
    Thanked 2,170 Times in 1,605 Posts
    Rep Power
    770
    Oh, what a well timed post! I shall be looking at this too

SHARE:
+ Post New Thread

Similar Threads

  1. Moodle - can you use images to represent categories on the frontpage
    By uraknai in forum Virtual Learning Platforms
    Replies: 14
    Last Post: 17th February 2012, 03:26 AM
  2. Replies: 0
    Last Post: 1st September 2010, 02:50 PM
  3. How can I use our webserver to run our intranet privatley??
    By chrisjako in forum Internet Related/Filtering/Firewall
    Replies: 9
    Last Post: 2nd April 2009, 03:43 PM
  4. What do you use to backup your File Stores?
    By darknova in forum Hardware
    Replies: 3
    Last Post: 11th November 2008, 09:51 PM
  5. Anyone use "Second Copy" to backup?
    By eejit in forum Windows
    Replies: 5
    Last Post: 18th October 2005, 03:03 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •