In SQL SERVER 2005 need database, before restore has done.

Hi,

Thanks for all supported till now . Today i face a new poblem.

Actually i restored stsConfig database from backup. But now i need the same old stsConfig Database.

I thought of using Rollback but i dont know exact way and syntax.

Can you help me on this.

Visual Studio Team System7

I'm going to move this to the TF Admin forum.

Are you trying to restore the database that was there before it got overwritten with the one from you restored from backup If you don't have a backup of the database that was overwritten, I'm not sure that you can do it unless you have some other program backing things up (for example, Windows system restore in Windows XP).

Buck

hi,

Ofcourse i dont have any other backup. Can't we rollback the restore operation .

Suresh,

You cannot rollback a restore operation. Your only option is to find a backup prior to the one you restored.