Solved

Backup skript

Posted on 2011-02-12
7
255 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
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 21

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
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.

 
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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Setting up a Microsoft WSUS update system is free relatively speaking if you have hard disk space and processor capacity.   However, WSUS can be a blessing and a curse. For example, there is nothing worse than approving updates and they just have…
I’m often asked about newer and larger USB drives connected to SBS2008 and 2011 failing Windows Server Backup vs the older USB drives not failing. As disk space continues to grow and drive technology change SBS2008 and some SBS2011 end up with the f…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
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…

770 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