Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kusumjain
Starting Member
21 Posts |
 Posted - 2008-10-01 : 14:33:36
|
| Guys anyone there please help, I am in big trouble. I was trying to restore a database from a database sanpshot. But then the power went off and the restore did not complete . When I started the server the database is still restoring. How do I stop it or do something to get the database up and running.Please help......Thanks,Kusum Jain |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-01 : 14:49:21
|
| I think you are reverting your database to your database snapshot. From msdn:Reverting a Database to a Database SnapshotA revert database operation (specified using the DATABASE_SNAPSHOT option) takes a full source database back in time by reverting it to the time of a database snapshot, that is, overwriting the source database with data from the point in time maintained in the specified database snapshot. Only the snapshot to which you are reverting can currently exist. The revert operation then rebuilds the log (therefore, you cannot later roll forward a reverted database to the point of user error). Data loss is confined to updates to the database since the snapshot's creation. The metadata of a reverted database is the same as the metadata at the time of snapshot creation. However, reverting to a snapshot drops all the full-text catalogs.Reverting from a database snapshot is not intended for media recovery. Unlike a regular backup set, the database snapshot is an incomplete copy of the database files. If either the database or the database snapshot is corrupted, reverting from a snapshot is likely to be impossible. Furthermore, even when possible, reverting in the event of corruption is unlikely to correct the problem.Restrictions on RevertingReverting is unsupported under the following conditions:The source database contains any read-only or compressed filegroups.Any files are offline that were online when the snapshot was created.More than one snapshot of the database currently exists. For more information, see Reverting to a Database Snapshot. |
 |
|
|
kusumjain
Starting Member
21 Posts |
Posted - 2008-10-01 : 14:52:44
|
| Yes I am reverting it. But I still see the database in restoring stage. I deleted the database sanpshot. How do I get out of the retore, or stop the restore.... |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-01 : 14:57:33
|
| Do you know that all changes since your database snapshots are lost by doing this? Do you have good full and tran log backup in place incase you are not able to restore original database? How big was your previous database? |
|
|
|
kusumjain
Starting Member
21 Posts |
Posted - 2008-10-01 : 15:00:50
|
| Yes ... I have a full backup and I am not worried about the data loss.Thanks,Kusum Jain |
|
|
|
kusumjain
Starting Member
21 Posts |
Posted - 2008-10-01 : 15:27:26
|
| Guys please help.....what can I do.. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-10-01 : 20:02:24
|
| Restore from your full database backup and the apply the transaction logs in sequence to get the database to the point in time that you want to get to.CODO ERGO SUM |
|
|
|
|
|
|
|
|
Urgent please help.......Restore