sglee
asked on
SQL Server Backup
Hi,I have Microsoft SQL Server 2000 running on Windows 2003 Server as a virtual machine in VMware box.
I am doing virtual machine backup using Nakivo backup software, but I like be able to backup SQL data separately if possible.
I thought about using ROBOCOPY, but then I heard that I can't copy open SQL database files until you shut it down first in order to copy files. If that is the case, I don't think it is a good solution.
So my question is - Can I use native Windows NT Backup program to backup the entire computer to an shared folder on the network, then would I be able to restore SQL database later from NT backup files (.BKF)? Since I don't deal with SQL database, I am not sure how backup & restore works on this.
For example, you can backup Word/Excel/Access/PDF type of files to a backup device and easily restore individual files or folders from your backup device that has .BKF file.
I just want to have an ability to restore SQL Server related information on-demand without restoring entire VM.
Thanks.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the link. Great article!
Question -
1. I assume once I go thru this process, it will create a task in Task Scheduler? In general area or Microsoft
2. Figure C. Integrity Check ---> How often do you think? My primary focus is to backup "SQL database".
3. During this time (whenever this maintenance task is running), will this prevent users from accessing SQL data thru front-end application software?
4. Figure E. ---> can I select a shared folder off the network? I plan on using external USB drive that is attached to a computer on the same network.
5. I will find out, but how long do you think it will take go thru the whole process - Integrity check and backup - on 25GB of MDF?
Question -
1. I assume once I go thru this process, it will create a task in Task Scheduler? In general area or Microsoft
2. Figure C. Integrity Check ---> How often do you think? My primary focus is to backup "SQL database".
3. During this time (whenever this maintenance task is running), will this prevent users from accessing SQL data thru front-end application software?
4. Figure E. ---> can I select a shared folder off the network? I plan on using external USB drive that is attached to a computer on the same network.
5. I will find out, but how long do you think it will take go thru the whole process - Integrity check and backup - on 25GB of MDF?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for your help and I appreciate it.
ASKER
"Why do you use such an old version?" ---> I know. But my client does not want to spend money to buy a new version. Everything is old - OS is old, SQL is old. But I am not the decision maker here.
"SQL Server Enterprise Manager. Then right-click on the database node. There is a Backup option." --> I am aware of that, but this would be manual intervention each and every day. Can I perhaps automate this process?