How can I restore selected ASP.NET Membership users from a backup DB? -


had recent issue cms , discovered today of users created in last week deleted. news have backup of db, , uses standard asp.net membership tables.

is there way restore of data without restoring whole db? membership tables of maze... there existing stored proc or utility out there? i'm not sure tables required , ones not.

i'm not aware of single sproc or utility this.

if you're using membership, you'll need copy from:

  • aspnet_membership
  • aspnet_users

if you're using roles you'll need copy from:

  • aspnet_usersinroles

if you're using profile you'll need copy from:

  • aspnet_profile

so it's not bad. need roll sleeves , write between 2 , 4 insert statements. (that's theory @ least)


Comments

Popular posts from this blog

python - Scipy curvefit RuntimeError:Optimal parameters not found: Number of calls to function has reached maxfev = 1000 -

c# - How to add a new treeview at the selected node? -

java - netbeans "Please wait - classpath scanning in progress..." -