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 |
|
ian jasper
Starting Member
1 Post |
 Posted - 2008-04-15 : 09:44:43
|
| While performing import actions I had a system freeze, when the system returned the sessions had been closed and the database had vanished, with the help of support we recovered the database only to find that the original project ID had a suffix attached ( Original 40/0110, New 40/0110-1 ), when I try to return it to it's original numbering convention it says it has to be a unique number which suggests to me it is not deleted but hiding in the background, can the original be recovered or is it possible to renumber the recovered database, I have searched the whole of the databases and the original is nowhere to be seen. |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2008-04-15 : 13:15:00
|
| Can you explain what you mean by project ID? Is this something generated by an application? It's not a SQL Server term.ThanksPaul RandalSQL Server MVP, Managing Director, SQLskills.com |
 |
|
|
|
|
|
database deletion