To restore a differential backup, the database itself must be in a RESTORING state i.e. the restore operations before this must have restored the database with the NORECOVERY or STANDBY...

> What is PSS

Microsoft Product Support Services.   See here for details.

Zipping backup file(s) can sometimes be inconvenient because you need additional space for the zip files, both during the backup and restore process.  Some compression applications require additional workspace while compressing...

SQL Server 2005 will support mirrored backups.  In the meantime, you can try our product, MiniSQLBackup, that can perform mirrored backups now.  In addition, the files are compressed and can...

Not sure what else your job might have been set up to do, but if it's only to backup the database, granting the user the db_backupoperator database role on the...

Most of the time, it's a permission error.  Is your SQL Server service started using the Local System account or a windows user account?  To use a network drive, it needs...

Have you tried using DBCC SHRINKFILE with a target size instead of TRUNCATEONLY?

From Books Online:

'Only a full database backup can be performed on the master database.'.

You can change the recovery model for the msdb database, but whether a full recovery model is...

Thus far, we have never encountered any errors when moving between SQL2K versions i.e. from Developer Edition to Std, to Enterprise, and vice-versa.  But then again, our databases do not use...

It is very important that you remember to detach the database before copying the mdf and ldf files to another server.  It is a common mistake to just stop the...

Give MiniSQLBackup a spin, at http://http://www.yohz.com.

Regards

Peter Yeoh

yohz Software