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

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

Database backups and restores are key to developing a secure environment for users’ information. A trusted backup plan is a requirement for on-premise and cloud instances. SQL Server database backups ...

SQL Server database corruption is troublesome for DBAs, particularly if the situation arrives suddenly and there is no backup. This situation can lead to prolonged downtime and permanent data loss in ...

There are times as a developer that you will want to be able to delete all the data from a database as efficiently as possible. Unfortunately, doing so may not be as easy as it seems. There are times ...

Transaction logs are a vital yet often overlooked component of database architecture. They are often forgotten because they are not something actively maintained like the schema contained within a ...

Help! My SQL Server Log File is too big!!! Your email has been sent Overgrown transactional log files can turn into real problems if they are not handled properly. Today SQL Server consultant Tim ...