Solved

Backup skript

Posted on 2011-02-12
7
257 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 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
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

A quick step-by-step overview of installing and configuring Carbonite Server Backup.
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

679 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