log shipping in SQL server 2008, failed

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.

All Forums

General SQL Server Forums

New to SQL Server Administration

log shipping in SQL server 2008, failed

Author

Topic

java148
Yak Posting Veteran

63 Posts

Posted - 2011-12-04 : 15:21:28

I tried the log shipping in SQL server 2008. but failed. Below is the error message. Looks like it is related to permission. I found that 'C:\mssql2008\test' folder , the shared folder in primary server PC, has only read-only permission. I tried to uncheck the read-only, but it didn't work.

please help.

Thanks



System.Data.SqlClient.SqlError: Cannot open backup device 'C:\mssql2008\test\ls\mtsnew.bak'. Operating system error 5(Access is denied.). (Microsoft.SqlServer.Smo)

sandy123
Starting Member

14 Posts

Posted - 2011-12-06 : 07:29:18

Check your service account has sufficient previleges on drive.
http://support.microsoft.com/kb/207187

sandy

java148
Yak Posting Veteran

63 Posts

Posted - 2011-12-07 : 09:36:22

thanks. I read that post. At home, I just have two PC linked through router, don't have domain controller. Then how to do it ?

Thanks


1.The SQL Server service must be started using a domain user account to access any resources on a remote computer. Verify that the MSSQLServer service is started under a domain account that has write access to both the Windows NT Server share and its underlying partition

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources