Actually I have very big size of databse. Also its back up is obvious that also biger size.
In case of only data loss of one table or view or sp or change then restore whole database then get back previous backup database & restore table i.e. it consuming too much time.
I want to restore only one table or view in faster way. how i can do it. plz give any suggestions
If you database was made of seperate files you could restore individual files.
To restore only a table you need a third party product such as litespeed.
I am not sure if any product can restore only schema components i.e views and sps. Standard practice is to keep the SQL scripts for Views and SPs. Do you not have these?
|||what is litespeed & how i can get it. give the idea plz
|||in sql server 2005 you can use Database snapshot as
a part of your backup and restore strategy.
A database snapshot is a readonly replica of your database
so in case a table is accidentally deleted, you can copy the deleted
data from the snapshot.
other use of the snapshot is for reporting purposes so this startegy will also
boost the database performance as well
No comments:
Post a Comment