In SQL SERVER 2005 need database, before restore has done.  
Author Message
Suresh .M.V





PostPosted: Team Foundation Server - Administration, In SQL SERVER 2005 need database, before restore has done. Top

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  
 
 
Buck Hodges





PostPosted: Team Foundation Server - Administration, In SQL SERVER 2005 need database, before restore has done. Top

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



 
 
Suresh VSTS QUERY





PostPosted: Team Foundation Server - Administration, In SQL SERVER 2005 need database, before restore has done. Top

hi,

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



 
 
Chandru R





PostPosted: Team Foundation Server - Administration, In SQL SERVER 2005 need database, before restore has done. Top

Suresh,

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