Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Backup to another network server Expand / Collapse
Author
Message
Posted Friday, August 16, 2013 9:54 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 3:28 PM
Points: 182, Visits: 650
Hi,
I am trying to backup from my sql 2005 DB which is on windows server 2003 to sql 2008R2 on windows server 2008R2 but getting access denied,
I have tried using SSMS, T-Sql but still getting issue with this.
I have created backup folder on my 2008R2 server and assign the full access to Everyone on security permission, I have added user and also grant the FUll Permission.

1) I tried using SSMS ut didn't work
2) I tried using T-sql, didn't work


I have just install the sql 2008R2 on Windows 2008 R2.
Post #1485433
Posted Saturday, August 17, 2013 2:27 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, September 15, 2014 12:19 AM
Points: 315, Visits: 510
Have you mapped a drive from the source server to the location on the remote server? You could use this drive letter then to access the remote backup folder.
Post #1485457
Posted Saturday, August 17, 2013 6:24 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, September 15, 2014 4:57 AM
Points: 802, Visits: 717
What is the service account for the instance you are trying to run BACKUP from? Make sure that it is a domain account. LocalSystem or somesuch is not likely to be succesful.

Erland Sommarskog, SQL Server MVP, www.sommarskog.se
Post #1485475
Posted Saturday, August 17, 2013 11:51 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, December 18, 2013 3:47 PM
Points: 13, Visits: 94
"I am trying to backup from my sql 2005 DB which is on windows server 2003 to sql 2008R2 on windows server 2008R2 but getting access denied" (You cant backup to SQL 2008 R2, you can only restore to it.. you might've meant backup to windows server.. just saying).

Erland is right Local system etc won't work. You need a domain account.
Are you manually executing it or is this a job?
When you are manually executing the script, I thought it uses your credentials. Perhaps I might not be right on this one. But on that destination folder, can you need to grant the (Domain account) service account running SQL and your domain login - rights to the folder and try?

-
Post #1485561
Posted Thursday, August 22, 2013 10:46 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 3:28 PM
Points: 182, Visits: 650
Thanks.
I tried using SSMS and T-sql and logged as administrator and assigned also access to everyone full control but didn't work.

Post #1487633
Posted Friday, August 23, 2013 12:52 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, September 15, 2014 4:57 AM
Points: 802, Visits: 717
It is not about what you are logged in as! It is what SQL Server is logged in as!

Open SQL Server Configuration Manager, find the service, select Properties, check the LogOn information. It should be a domain account not LocalSystem.


Erland Sommarskog, SQL Server MVP, www.sommarskog.se
Post #1487650
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse