Solved

Backup for SQL 2008 on Window 2008

Posted on 2014-01-04
6
561 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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
A safe way to clean winsxs folder from your windows server 2008 R2 editions
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

778 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