Environment:
Windows 2003 R2 SP2 Server
SQL 2005
ASP 1.1 2.0. 4.0
ASPDOTNETSTOREFRONT ([login to view URL]) Shopping cart
Issue:
We experienced a power failure on our physical machine and after restoring power, web users cannot access our shopping cart. The Event Viewer indicates ID3005, unable to login to database with user "sa" and our database is listed as (suspect) in SQL Visual Studio 2005.
We have one file system backup as of 3/1/2013 and no SQL-state backups configured. Our immediate task is to recover the database, restore user access to the shopping cart and restore web functionality. Additionally, we would like to configure SQL-state backups as well as daily file system backups as recommended.