Very fresh MS SQL user calling. And I made horrible mistake, i am asking if possible to roll it back.
I am running MS SQL 2008 Developers edition. What I accidentally did is deleting the very one DB user on my local server!!!!! I have several DBs so it is very important to get back to my previous state.
Any chance? Please help me.
asked Mar 29, 2010 at 06:33 AM in Default
Did you take a backup?
Check "C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA" (this may differ depending on your installation). It maybe that the mdf and ldf of the database are still in the data folder. If so you can try re-attaching the mdf
answered Mar 29, 2010 at 06:43 AM