CODEWITHSUNDEEP
sql-serversql-server-2005
Bharanikumar
Bharanikumar

Reputation: 25733

Rollback changes

I don't know about MSSQL , i have two site one is php and another site is cold fusion ,

My php site using mysql , my cold fusion using the MSSQL ,

my old site is the cold fusion still we are using cold fusion and , becoz it is old site

lot of records in sql, still we are moved to mysql ,

Now what happen suddenly ,

couple of days back , site admin ,

for migration purpose (SQL TO MYSQL) , for full access reason , by mistake, instead of

giving full permission level to juniors, by mistake site super admin deleted the all users ,

So that users related records are suffled to super admin ,

now i want to do all revert ,

What should i do now,

Any ideas ? corruption done on MSSQL ,

This are happened couple of days back,

Now i want revert all change ,

Any suggestions ,

Thanks for edited ,

My SQL server version is 2005

Upvotes: 0

Views: 228

Answers (2)

user474407
user474407

Reputation:

What version is the MSSQL server(2000, 2005, 2008) ? If it is SQL 2000, then you can try out SQL Log Rescue from red-gate.

All the best.

Upvotes: 0

GvS
GvS

Reputation: 52518

I hope you can do a:

 RESTORE DATABASE { database_name | @database_name_var }  [ FROM <backup_device> [ ,...n ] ]

Basicly: put back a backup.

Upvotes: 2

Related Questions