October 13, 2008 at 8:08 am
hello all (urgent) for me
help me any one i tried to restore the back up file it shows bellow error.
This is for source system details:
product version:9.00.1399.06
productLevel:RTM
Server Property:Express Edition
now i want to restore these back up in bellow server property system.
destination system.[b]This name is VSTS (visual studio team system)[/b]product version:9.00.3042.00
productLevel:sp2
Server Property:Express Edition.
In this process i am facing problem .I got this type of error message .
please help me .I am new for sql server 2005
Error:An exception occurred while executing a transact sql statement or batch (Microsoft sql server connectioninfo)
Additional Information:
Cannot open backup device "C:program files \Microsoft sql sesrver \MSSQL\MSSQL$\MSSQL\Backup\FLMDB.bak",operating system error (access is denied) RESTORE HEADER ONLY
is termination obnormally:
due to this problem i am struggling a lot.PLease help me.
thank you.
Thanks
Dastagiri.D
October 13, 2008 at 9:32 am
It's a rights issue. When you submit a backup comment, it's not your account running the backup, it's the SQL Server service. That service needs rights to that folder.
October 13, 2008 at 10:45 pm
sir,
I can't able to understand u r answer.
explain some more.
Thank you
Dastagiri.D
Thanks
Dastagiri.D
October 14, 2008 at 12:02 am
You need permission on backup folder. check with your administrator.
October 14, 2008 at 1:37 am
The account that SQL Server is running as (the SQL Server service account) needs to have permission to access that folder.
Check what accounts have permissions on that folder
Check what account SQL is running as (fropm SQL configuration manager)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 14, 2008 at 6:46 pm
If u don't mind ,I am new in sql server 2005..
could u please explain me in detail..where I change pemissions
Thank you.
Dastagiri.D
Thanks
Dastagiri.D
October 14, 2008 at 9:46 pm
The permissions are not within SQL Server but at the file level or at the folder where the backup file is located. Typically those permissions are maintained by a Windows sysadmin but if not then you will need to right click on the windows share (folder on the specified drive) and select Properties, Select the Security tab and ensure that the user running the restore / backup has permissions to that folder. You may actually need to go to the advanced section and verify permissions are correctly set up there as well.
Ultimately if you are not really familiar in this area you can cause harm and allow for access levels to others that may not be appropriate so, be careful and seek assistance.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 14, 2008 at 11:08 pm
I tried what u have suggested to me.Its working fine.
Thank you
Dastagiri.D
Thanks
Dastagiri.D
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply