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.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 restore a deleted autonumbering id

Author  Topic 

mike13
Posting Yak Master

219 Posts

Posted - 2013-07-30 : 15:02:28
Hi,

Accidentally some one deleted a record (product option) from my DB
and i related to id (auto numbering)
is there a way to put restore, put the nr back?

thanks a lot

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2013-07-30 : 15:55:31
Yes. Do a tail backup and the latest backup.


Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
Go to Top of Page
   

- Advertisement -