Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 10850

Making copies of data which may be restored after a data loss event or to recover data from some earlier point in time.

1
vote
This turned out not to be an error with the backup, but with the restore command that I was using. RESTORE verifyonly FROM DISK = @backupFile WITH FILE=1, STATS=5, MAXTRANSFERSIZE=4194304 … returned the error "Damage to the backup set was detected" some whereas RESTORE verifyonly FROM DISK = @backupFile WITH FILE=1, STATS=5 returned "The backup set on file 1 is valid." Which is …
answered Apr 8 '14 by paulH
7
votes
1answer
I've just completed writing a backup statement for a reasonably large database (1.3 TB), and I've been testing it out using a much smaller database (10 GB + 10GB log file). The backup writes to three … destinations. During the testing I noticed that whilst the backup is running each backup file is about 1.2 GB in size, but once the backup process has completed the files shrink to less than 600 MB …
asked Jan 11 '13 by paulH
2
votes
1answer
I have a database that seems to be functioning fine with no apparent errors except that any full backup taken is broken - attempting a restore fails with an error "RESTORE detected an error on page … (18469:-1767164485)" DBCC CheckDB on the database completes without errors. EDIT #1 The backup is created with the following command: BACKUP DATABASE @DatabaseName TO DISK = @backupFile1, DISK …
asked Apr 8 '14 by paulH