Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SOS-syslogin truncated

Status
Not open for further replies.

RajD

Technical User
Joined
Aug 23, 2001
Messages
53
Location
US
Hi guys,

One of my friend truncated syslogins on master database on a 'SQL Server 6.5' server.

Is there anyway to restore it???

There is no backup available on this recently built server and it has few databases on it.

Pl help.

Thanks
 
Sorry Rajd but as there is no backup there is no way you will be able to get the data back. You will have to enter all the required logins again.

Be aware that you will have to tidy up the sysusers table in each of your user databases before you start. The user id's there will have been orphaned due to the truncate of syslogins.

Rick.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top