<div>
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.<br />
<br />
Windows Backup is to back up general things, not databases.
</div>


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.

<div>
No just database, but whole server for disaster recovery.
</div>


No just database, but whole server for disaster recovery.

<div>
<div class="content wysiwyg-content">
Can I simply use Window 2008 R2 Backup to fully recover my SQL 2008 during disaster recovery ? <br />
<br />
Is there step by step guide to show me how to setup the backup procedure on the server ?<br />
<br />
Tks
</div>
</div>


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

Backup for SQL 2008 on Window 2008

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.