Backup for SQL 2008 on Window 2008

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
AXISHKAsked:
Who is Participating?
 
Lee SavidgeCommented:
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
 
Lee SavidgeCommented:
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
 
Lee SavidgeCommented:
Here is how to set up a maintenance plan for SQL 2008:

http://technet.microsoft.com/en-US/sqlserver/dd430301
0
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

 
AXISHKAuthor Commented:
No just database, but whole server for disaster recovery.
0
 
Anthony PerkinsCommented:
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
 
AXISHKAuthor Commented:
Tks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.