Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 715
  • Last Modified:

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
0
AXISHK
Asked:
AXISHK
  • 3
  • 2
3 Solutions
 
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
 
AXISHKAuthor Commented:
No just database, but whole server for disaster recovery.
0
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 
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
 
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.

Join & Write a Comment

Featured Post

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.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now