Re: Quick and Easy question
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
Date: Wed, 28 Jul 2004 22:51:40 +0100
A database is unavailable while it is being restored (although it can be in
use while being backed-up). You can control the placement of individual
tables and indexes on filegroups and then backup or restore those filegroups
individually. You can also do a point-in-time restore which allows you to
roll back to a point before any data loss or corruption occurred.
However, you seem to be asking the wrong question. I don't know Exchange but
in SQLServer the solution to your problem is to implement user/object based
permissions so as to prevent users from deleting data that they are not
authorized to delete.
--
David Portas
SQL Server MVP
--
Relevant Pages
- Re: DFHSM QUESTION : ATTEMPTING TO FIND MIGRAT2 VOLSER
... Another possibility is to restore a backup of the MCDS either under a different name or on a test system from a time when the ds was still on ML2 and find the record corresponding to the dataset. ... Also, see discussion of OA20117, OA20907, and "DFDSS Data Loss" that went on in 2007 on IBM-main. ... If you have DFSMShsm FSM enabled and have ever moved volumes with dss DUMP FULL, RESTORE FULL before implementing the patch in OA20907, you have been exposed to data loss on restored volumes in the form of failure to physically migrate a changed dataset under the assumption a back-level version on ML2 was identical. ... Search the archives at http://bama.ua.edu/archives/ibm-main.html ...
(bit.listserv.ibm-main) - Re: Erro in Online bkp in exchange 5.5
... > I don't have onlne backup to restore to eliminate 1018 ... > error.Offline bakup what I have is one month old, ... > resolve the problem if I restore that. ... Repair almost certainly will cause data loss. ...
(microsoft.public.exchange.admin) - Re: Can not restore
... restore is not working at all. ... System Restore is very unreliable and can lead to data loss, ... separate drive or partition. ...
(alt.os.windows-xp) - Re: VLDB backups and partial restore
... if you do filegroup backups of the ... filegroups, which is different from doing a 'partial' restore. ... > like to restore configuration data and partial operational data ...
(microsoft.public.sqlserver.server) - RESTORE an Old Filegroup into an UpTodate Database
... I am going to implement a strategy for archiving and restoring old ... filegroups. ... The restore strategy is going to work as this: ... restore the requested filegroup to the new SQL Server as well. ...
(comp.databases.ms-sqlserver) |
|
