Solved

Backup skript

Posted on 2011-02-12
7
258 Views
Last Modified: 2012-05-11
Hello!

Can you please advise me how to set up a daily (full) backup of databases on my SQL 2005?
I already have RAID (mirror), but I also want to backup databases to second location - USB disk or. sth. Operating system is MS Windows SBS 2003 Premium.
Step by step instructions are recomended.

Thanks for the help!
0
Comment
Question by:celjan79
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 22

Accepted Solution

by:
Om Prakash earned 64 total points
ID: 34878382
0
 
LVL 29

Assisted Solution

by:mass2612
mass2612 earned 62 total points
ID: 34878409
Hi,

If you are new to SQL I would suggest using the Maintenance Plan Wizards. This might help you to start.

Creating Backup Jobs in SQL Server 2005
http://www.sql-server-performance.com/articles/dba/creating_backup_jobs_p1.aspx

0
 
LVL 22

Assisted Solution

by:Larry Struckmeyer MVP
Larry Struckmeyer MVP earned 62 total points
ID: 34878496
Hi:
if you use the SBS bult in backup to external usb drive you will get a useable/restorable backup of everything on the SBS.  You question does not say if the SQL server is on the SBS or not, and the maintenance plan is still a good idea, but you can use the maintenance plan to backup the SQL data to an internal disk (not the one one which houses the SQL) and the SBS backup will then backup both the database and the backup of the database.

You can also send the Maintenance plan copy to another drive on the network.

And  in all cases you should rotate the external drives so that one is out of the building at all times.  This requires at least three.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 5

Assisted Solution

by:NARANTHIRAN
NARANTHIRAN earned 62 total points
ID: 34894226
Run the below query in the query analyzer.

backup database databasename to disk = ' Specifly the drive'

and u can
add this query to sql server agent to take backup automatically as per the schedules.  
0
 

Author Comment

by:celjan79
ID: 35017118
NARANTHIRAN: does this command also stop / start SQL Server when doing backup?
0
 
LVL 16

Expert Comment

by:Ady Foot
ID: 35446388
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

739 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