The ‘Suspect’ mode of the SQL database indicates that the recovery process has started but failed to complete. The database goes into suspect mode if the primary data file is damaged or the database ...

This is a user generated content for MyStory, a YourStory initiative to enable its community to contribute and have their voices heard. The views and writings here ...

Database backups and restores are a fundamental (and critical) skill-set of any MS SQL Server DBA. A solid backup plan is a requirement for most on-premise instances and things are no different in the ...

We currently have a SQL 2008 server running as a VM. We backup nightly using Veeam and my consultant also advise we backup on top of that via BackupExec. Lately, our Backupexec jobs have been running ...

This article explains how to repair the MDF file using the native repair methods and how to use a Reliable MDF file Repair ...

One way that organizations are storing data in the cloud is by moving their databases to the cloud. What once meant building an entire physical server, patching it, installing software like Microsoft ...

In Enterprise Manager, when you view the properties of the database, there's a field stating the size of the database and the amount of free space left.<BR><BR>I was wondering, what would happened if ...

My client, an intelligent solutions company is looking for an experienced MS SQL Database Administrator to join their team. The role involves full deployment and maintenance of MS SQL environment & ...