Solved

Backup skript

Posted on 2011-02-12
7
264 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
Free NetCrunch network monitor licenses!

Only on Experts-Exchange: Sign-up for a free-trial and we'll send you your permanent license!

Here is what you get: 30 Nodes | Unlimited Sensors | No Time Restrictions | Absolutely FREE!

Act now. This offer ends July 14, 2017.

 
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

Free NetCrunch network monitor licenses!

Only on Experts-Exchange: Sign-up for a free-trial and we'll send you your permanent license!

Here is what you get: 30 Nodes | Unlimited Sensors | No Time Restrictions | Absolutely FREE!

Act now. This offer ends July 14, 2017.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…

696 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