Solved

Backup for SQL 2008 on Window 2008

Posted on 2014-01-04
6
552 Views
Last Modified: 2014-01-11
Can I simply use Window 2008 R2 Backup to fully recover my SQL 2008 during disaster recovery ?

Is there step by step guide to show me how to setup the backup procedure on the server ?

Tks
0
Comment
Question by:AXISHK
  • 3
  • 2
6 Comments
 
LVL 25

Expert Comment

by:Lee Savidge
ID: 39756044
Do you want to back the database up? If so, use SQL Servers inbuilt backup functions as it will do it properly. Either that or buy a specialised package like BackupExec to do it.

Windows Backup is to back up general things, not databases.
0
 
LVL 25

Assisted Solution

by:Lee Savidge
Lee Savidge earned 334 total points
ID: 39756048
Here is how to set up a maintenance plan for SQL 2008:

http://technet.microsoft.com/en-US/sqlserver/dd430301
0
 

Author Comment

by:AXISHK
ID: 39756062
No just database, but whole server for disaster recovery.
0
Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

 
LVL 25

Accepted Solution

by:
Lee Savidge earned 334 total points
ID: 39756158
I would back the database up separately anyway. For DR see here:

 http://technet.microsoft.com/en-us/library/cc770266(v=ws.10).aspx
0
 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 166 total points
ID: 39756755
Can I simply use Window 2008 R2 Backup to fully recover my SQL 2008 during disaster recovery ?
No.  Not unless you are prepared to shutdown the SQL Server service (this is very rarely a good idea).
0
 

Author Closing Comment

by:AXISHK
ID: 39773238
Tks
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

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.
OfficeMate Freezes on login or does not load after login credentials are input.
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

867 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

26 Experts available now in Live!

Get 1:1 Help Now