Skumar
13th September 2009, 09:14
Dear guru’s

While restoring SQL backup on server, we are got the error” BackupMedium::Reportloerror: read failure on backup drive’\\.\tape0’ operating system error 23( data error (cyclic redundancy check)) “ then we close this error message and restart the server and then we tried to open database but not responding it gives error “ a connection could not be established to server- cannot open user default database ‘<ID>’ using master database instead”,

We don’t know SQL SA password, because person who left the job has not given.

Please help me out.

Thanks & Regards
shailesh

learner
18th September 2009, 23:29
although i am not a ms sql server expert, but this url

http://www.mssqlcity.com/FAQ/Admin/forgot_sa_password.htm

might help u in resetting sa password for ur db ... try doing some googling.

regards

learner