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 ...
19th August 2011, 10:12 PM #1
[ANSWERED] Can I use NTBackup to backup MSSQL 2005 databases?
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.
Last edited by link470; 19th August 2011 at 10:45 PM.
19th August 2011, 10:30 PM #2
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.
Thanks to localzuk from:
link470 (19th August 2011)
19th August 2011, 10:34 PM #3
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!
19th August 2011, 10:40 PM #4
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
"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
2 Thanks to localzuk:
elsiegee40 (20th August 2011), link470 (19th August 2011)
19th August 2011, 10:45 PM #5
I'll give that a try! Thanks a lot.
This method appears to work great. Thanks again!
Last edited by link470; 20th August 2011 at 01:53 AM.
20th August 2011, 06:48 AM #6
Oh, what a well timed post! I shall be looking at this too
By uraknai in forum Virtual Learning Platforms
Last Post: 17th February 2012, 03:26 AM
By DaveP in forum General Chat
Last Post: 1st September 2010, 02:50 PM
By chrisjako in forum Internet Related/Filtering/Firewall
Last Post: 2nd April 2009, 03:43 PM
By darknova in forum Hardware
Last Post: 11th November 2008, 09:51 PM
By eejit in forum Windows
Last Post: 18th October 2005, 03:03 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)