Microsoft added the option of using the Azure Backup service to provide recovery support for SQL Server 2008 and SQL Server 2008 R2 when those workloads are hosted on Azure virtual machines. The Azure ...

本文将探讨SQL Server 2008使用的恢复模式的选择，以及可用于备份一个数据库的各种方法，如差异备份和事物日志备份。此外，事务日志备份也将被介绍，该机制使恢复模式成为可能。备份，事务日志，以及恢复模式是相互关联，当设置的一个时将影响影响的另一 ...

I've been scratching my head about this for quite some time and can't quite figure it out. I have a share on Server1 (Windows 2008 R2) and Server2 (Windows 2012 R2) that I use to store SQL backups ...

本文将探讨SQL Server 2008使用的恢复模式的选择，以及可用于备份一个数据库的各种方法，如差异备份和事物日志备份。此外，事务日志备份也将被介绍，该机制使恢复模式成为可能。备份，事务日志，以及恢复模式是相互关联，当设置的一个时将影响影响的另一 ...

Using compression with SSMS is just as easy. Simply set the compression option on the Options page of the Back up Database dialog. You may be asking yourself: How effective is this compression? The ...

One of the great new features of SQL Server 2008 is called Transparent Data Encryption. Data encryption was introduced into the Database Engine in SQL Server 2005, so why is 2008 so much better? Yes, ...

SQL Server 2008系统诞生于08年3月13日，在微软2008新一代企业应用平台与开发技术发布大会上，微软宣布向企业用户大众同时发布三款核心应用平台产品：Windows Server 2008、Visual Studio 2008、SQL Server 2008，此次微软发布的三大产品对企业实现“动态IT”愿景。随着Windows ...

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...