Viewing 15 posts - 16 through 30 (of 341 total)
SQL Verify from Yohz Software does all of the stuff that clubbavich mentions i.e.
- compute file checksums
- copy backup files to secondary locations
- restore backup files, and optionally run database...
July 24, 2011 at 9:33 pm
After copying the model data files from a working instance and get your instance started, you could just restore from the backups you made previously.
July 1, 2011 at 5:15 am
Have you tried restoring the database using SQL Server natively, without SQL Virtual Restore, and see if you get the same error?
June 2, 2011 at 6:51 pm
Differential backups? They only back up pages that have changed since the last full backup, and are cumulative. This means that you only need to restore the last...
May 23, 2011 at 7:12 pm
dso808 (5/19/2011)
Which disk is the best place to store the backups from a performance stand point?
May 20, 2011 at 6:59 am
Looks like an error in the script/stored procedure. Suggest you debug the script/stored procedure in a query window, and use PRINT statements liberally around line 256 to see what's...
May 17, 2011 at 5:09 am
The backup process is as Steve described, except for point 3
Now all log pages from 3:00am to 3:25 are added to the backup.
which will depend on whether there...
May 13, 2011 at 9:44 pm
Any chance it has something to do with the drive where the undo file is located, or perhaps you have some filter drivers that's intercepting the disk calls and performing...
May 9, 2011 at 4:09 am
Or run
DBCC TRACEON(3004, 3605,-1)
to get detailed progress about the restore process in your SQL Server log file.
May 6, 2011 at 8:38 am
That's certainly a big difference of 8 hours between the 2 servers to restore that transaction log. I know it's a long shot, but any chance the SQL Server...
May 6, 2011 at 8:24 am
6 hours does look like an extremely long time to create the undo file, even if the entire 5.5 GB contains uncommitted transactions. Can you compare the restore speed...
May 6, 2011 at 1:34 am
As stated by the other guys, a backup file only contains data pages that are actually used. If you run the following script:
CREATE DATABASE sizetest ON PRIMARY(NAME = 'sizetest_data',...
May 2, 2011 at 4:04 am
To add to the above, you can run this query to see exactly how much data is being backed up for your database.
SELECT database_name, backup_start_date, backup_size, compressed_backup_size
FROM msdb..backupset
WHERE...
April 29, 2011 at 6:56 am
Disclaimer: I have no experience using CommVault, and the following is only based on my experience working on SQL Backup for the last 7 years.
Is it possible that CommVault is...
April 21, 2011 at 10:37 am
GilaMonster (6/17/2010)
April 4, 2011 at 10:01 am
Viewing 15 posts - 16 through 30 (of 341 total)