Solved

Backup skript

Posted on 2011-02-12
7
252 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
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

You may have discovered the 'Compatibility View Settings' workaround for making your SBS 2008 Remote Web Workplace 'connect to a computer' section stops 'working around' after a Windows 10 client upgrade.  That can be fixed so it 'works around' agai…
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

920 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

17 Experts available now in Live!

Get 1:1 Help Now