Archive for the ‘databases’ Category

SQL2005 Shrink Transaction Logs

Sunday, November 11th, 2007

There are a lot of articles to be found on this subject but here is a condensed procedure:

Your SQL transaction log is too big and you need to shrink it before SQL server explodes through lack of disk space:

  1. Back up your database - optional but a good idea as you are about to invalidate your transaction log backup history (more…)

SQL2005 backup of the file or filegroup is not permitted because it is not online

Sunday, November 11th, 2007

While trying to backup a SQL database using Microsoft SQL server management studio the following error occurs:

Microsoft SQL Server Management Studio
——————————

Backup failed for Server ‘ServerName’. (Microsoft.SqlServer.Smo) (more…)