Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mcaizpp
Starting Member
1 Post |
 Posted - 2008-10-08 : 10:40:36
|
| Hello, I am trying to overwrite an existing db with a backup from our production server. The problem is I keep getting the error - An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)------------------------------ADDITIONAL INFORMATION:Cannot open backup device 'C:\backups\TransferValue-2008-10-08-1124.bak'. Operating system error 5(error not found).RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201)Al first I thought the backup was corrupt but 2 people in my team were able to restore the db and I was not. Has anyone ever received this error before? If so how did you resolve it. My login is a sysadmin and i have just given my widnows login (same as sql server login) administrator rights.I do think this is some sort of windows rights problem or SQL login rights issue.Thanks in advance. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-10-08 : 11:41:28
|
| in sql configuration manager choose sql server 2005 servicesright click on the SQL Server service.choose propertieson logon tab choose built-in account: local systemthat should be enough._______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.1 out! |
 |
|
|
|
|
|
backup problem