Solved

Backup for SQL 2008 on Window 2008

Posted on 2014-01-04
6
575 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
[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
  • 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
OfficeMate Freezes on login or does not load after login credentials are input.
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…

756 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