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

If the SQL Server crashes, especially if there ... but they are a good start to forming a sound database backup and recovery strategy. Most importantly, they allow for a single DBA to perform ...

Defining Managed SQL Services Managed SQL services are cloud-based solutions that give users access to SQL databases without needing to manage the underlying infrastructure. This means the service ...

SQL Server is at the heart of your company; if it goes down, the results could be catastrophic. However, despite its importance, many IT admins don’t have a solid backup and restore plan in place.

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

In the absence of a diligently tested and documented strategy, SQL Server disaster recovery ... log records created since the last full backup. It allows point-in-time recovery of SQL Server databases ...

We currently have a SQL 2008 server running ... if I still need to backup via BackupExec if Veeam is backing it up on a nightly basis. Seems redundant no? If there is a database corruption ...

There are many things to consider when capacity planning for SQL Server. Storage and disk capacity are apparent, but when you want to right-size your database(s) for a new SQL implementation or ...

SQL Server lets you disconnect a database from the main server program, allowing you to make safe backup copies or send data to branch offices. Once you disconnect a database, you must restore it ...

and even the ability to store and run database files directly in Windows Azure storage." While SQL Server 2014 CTP2 has built-in Windows Azure backup support, Microsoft plans to extend that ...