Viewing 11 posts - 331 through 341 (of 341 total)
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...
July 7, 2004 at 8:38 pm
> What is PSS
Microsoft Product Support Services. See here for details.
July 3, 2004 at 10:52 pm
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...
July 1, 2004 at 9:36 am
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...
July 1, 2004 at 9:31 am
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...
June 26, 2004 at 4:41 am
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...
June 25, 2004 at 10:01 am
Have you tried using DBCC SHRINKFILE with a target size instead of TRUNCATEONLY?
June 24, 2004 at 11:09 am
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...
June 23, 2004 at 9:38 am
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...
June 20, 2004 at 11:03 am
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...
June 20, 2004 at 8:25 am
June 19, 2004 at 9:21 am
Viewing 11 posts - 331 through 341 (of 341 total)