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 |
|
amirs
Constraint Violating Yak Guru
260 Posts |
 Posted - 2010-10-20 : 00:02:19
|
| Dear member i have restore a database to give a backup file in network path but their is following error is diaplayThe Database Engine service could not resolve the specified file location. Either the location does not exist, or the current login account does not have access to it. Verify that the file location exists, and that the login account has permissions on it.the file location is correct . i have full right to access this folder in network path.and i have check this account in sql server agent log on property it is administrative rights.so please tell me what is error |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
amirs
Constraint Violating Yak Guru
260 Posts |
Posted - 2010-10-20 : 00:54:37
|
| thanks to replay mam it is correct and it is work.one another questionI am using a sql2008 my database backup size is 11 GB and mdf file size of this database is near about 19 GB and log filesize is 1.5 GB . so it is correct. it my knowledge the backup size of database is near to mdf file size of database.so please guide it is correct or wrong |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
amirs
Constraint Violating Yak Guru
260 Posts |
Posted - 2010-10-20 : 01:16:33
|
| yes error is clear it is permission problem |
|
|
|
|
|
|
Restore backup in network path