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

Click to viewBacking up your data on a regular basis is important, and turning a spare computer into a backup server is often the best way to make sure it gets done. But most methods require either a ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Dany Lepage discusses the architectural ...

If you are not a database administrator, this doesn’t mean you can’t have amazing SQL Server backup and recovery. In this webinar, Andrew Zhelezko from Veeam will present on a number of capabilities ...

I'm down on SQL Server Management Studio right now. I basically just spent a day trying to swap out the evaluation version of SQL Server 2008 R2 with the Express version, and SSMS just wouldn't ...

Pity the poor modern DBA, now that SQL Server gets attacked by some of the same scripts that PCs do. Pity the poor modern DBA who has to keep building Microsoft SQL Servers because some idiot vice ...

The latter securely sends your data to the backup company's servers for off-site storage. However, backup companies frequently let you choose your preferred method—or use both. As a result, we now ...

In a post to Microsoft’s Windows Server blog, Microsoft Senior Program Manager Gaurav Gupta revealed that the company will offer an integrated cloud backup service for Windows Server “8”(the current ...