Solved

SQL Server Backup

Posted on 2016-09-25
7
18 Views
Last Modified: 2016-11-08
SQL Server Ent MgrSQL 2000Windows Native BackkupHi,
 
 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.
0
Comment
Question by:sglee
  • 3
  • 3
7 Comments
 
LVL 32

Assisted Solution

by:ste5an
ste5an earned 500 total points
ID: 41814652
SQL Server has its own backup mechanism. Open the database node in the SQL Server Enterprise Manager. Then right-click on the database node. There is a Backup option.

backup20001.png
And: Why do you use such an old version? It's unsupported since years. It's dangerously unsecure to run such a system with internet access.
0
 

Author Comment

by:sglee
ID: 41814658
@ste5an
"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?
0
 
LVL 32

Accepted Solution

by:
ste5an earned 500 total points
ID: 41814672
Sure, create a maintenance plan.
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

Author Comment

by:sglee
ID: 41814678
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?
0
 
LVL 32

Assisted Solution

by:ste5an
ste5an earned 500 total points
ID: 41814690
1. No, it creates an SQL Server Agent job. Thus the SQL Server Agent service must be enabled and running.
2. At least once a week. Integrity corruption can be often repaired when done often enough. When the periods inbetween increase, then the risk for data loss increases.
3. That is the advantage of SQL Server backup. It's done in the background and the database are online.
4. Afair no. SQL Server 2000 supports only local drives. Cause otherwise it could not guarantee a working backup file. Just create the backup locally and use a scheduled task to copy the backup file to a different location.
5. hmm, 5 minutes?
0
 

Author Comment

by:sglee
ID: 41814700
Thanks for your help and I appreciate it.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

Suggested Solutions

Are you looking to recover an email message or a contact you just deleted mistakenly? Or you are searching for a contact that you erased from your MS Outlook ‘Contacts’ folder and now realized that it was important.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

743 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

12 Experts available now in Live!

Get 1:1 Help Now