SQL Server 2008 Installation Strategies and Best Practices Part 2 of 5 Greetings, last week I initiated this blog series which focuses on best practices and installation strategies when deploying ...

Despite its importance, many IT admins don’t have a solid SQL Server backup and restore plan in place. This guide from Virtualization Review is the first step in developing that plan.

You can create a Full Backup to restore database in SQL Server using the SQL Server Management Studio (SSMS). For this, open SSMS, right-click the database, and select Tasks > Back Up.

The transaction log file contains the SQL Server transactions of the database. It basically records the database transactions and the changes made by the transactions to the database. The logs are ...

One configures SQL Server for high availability (HA) in anticipation of some event that will cause a critical application to go offline unexpectedly-a software glitch that causes an app to freeze or a ...

How to Restore a SQL Database From a .MDF File. Computer database software such as Microsoft's SQL Server benefits all types of businesses, as it makes recordkeeping fast, flexible and secure.

Microsoft is having a re-think about its SQL Server strategy and in particular about what it wants to do with SQL Data Services.Part of the company’s Azure services platform, SQL Data Services ...

Joey on SQL Server How To Be a Better DBA: 4 Strategies To Improve SQL Server Performance There are plenty of ways to get the most out of SQL Server without just upgrading to the latest version.

Do a restore and see if you can recover the applications. That is where you find things like the hosting provider doesn't shut down the database (s) that wordpress uses so the backup is useless.