How can i take backup's on remote server path directly??
-
Hi All, This is the code i am running.. BACKUP DATABASE [Outbound_Vodafone] TO DISK = N'\\dataserver\Database\Outbound_VodafoneDifferential_9PM.bak' WITH DIFFERENTIAL , INIT This path is already shared to my domain user login. But I am getting this exception.. Msg 3201, Level 16, State 1, Line 1 Cannot open backup device '\\dataserver\Database\Outbound_VodafoneDifferential_9PM.bak'. Operating system error 5(Access is denied.). Msg 3013, Level 16, State 1, Line 1 BACKUP DATABASE is terminating abnormally. Please help!! Regards, Amandeep Singh
Which version are you using (it looks like one of MS SQL). If you are using SQL 2000 you may not be allowed to backup to a different system.
-
Hi All, This is the code i am running.. BACKUP DATABASE [Outbound_Vodafone] TO DISK = N'\\dataserver\Database\Outbound_VodafoneDifferential_9PM.bak' WITH DIFFERENTIAL , INIT This path is already shared to my domain user login. But I am getting this exception.. Msg 3201, Level 16, State 1, Line 1 Cannot open backup device '\\dataserver\Database\Outbound_VodafoneDifferential_9PM.bak'. Operating system error 5(Access is denied.). Msg 3013, Level 16, State 1, Line 1 BACKUP DATABASE is terminating abnormally. Please help!! Regards, Amandeep Singh
Have you try this?
BACKUP DATABASE DatabBasename
TO DISK = 'C:\BackUp\databasenamebackup.bak'
WITH FORMAT;
I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com
-
Which version are you using (it looks like one of MS SQL). If you are using SQL 2000 you may not be allowed to backup to a different system.
I am using SQL server2005!!
-
Have you try this?
BACKUP DATABASE DatabBasename
TO DISK = 'C:\BackUp\databasenamebackup.bak'
WITH FORMAT;
I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com
Please understand i want to take backup's on some other server, not on the local.
-
Hi All, This is the code i am running.. BACKUP DATABASE [Outbound_Vodafone] TO DISK = N'\\dataserver\Database\Outbound_VodafoneDifferential_9PM.bak' WITH DIFFERENTIAL , INIT This path is already shared to my domain user login. But I am getting this exception.. Msg 3201, Level 16, State 1, Line 1 Cannot open backup device '\\dataserver\Database\Outbound_VodafoneDifferential_9PM.bak'. Operating system error 5(Access is denied.). Msg 3013, Level 16, State 1, Line 1 BACKUP DATABASE is terminating abnormally. Please help!! Regards, Amandeep Singh
I really don't know much about this, but the access denied message suggests the backup is trying to do something on that disk that is restricted by permissions. You say that this disk is shared to your login, but are you sure that you have full access control on it; can you read and write and create directories etc?
It's time for a new signature.
-
Hi All, This is the code i am running.. BACKUP DATABASE [Outbound_Vodafone] TO DISK = N'\\dataserver\Database\Outbound_VodafoneDifferential_9PM.bak' WITH DIFFERENTIAL , INIT This path is already shared to my domain user login. But I am getting this exception.. Msg 3201, Level 16, State 1, Line 1 Cannot open backup device '\\dataserver\Database\Outbound_VodafoneDifferential_9PM.bak'. Operating system error 5(Access is denied.). Msg 3013, Level 16, State 1, Line 1 BACKUP DATABASE is terminating abnormally. Please help!! Regards, Amandeep Singh
Sometimes I have the same problem on some clients servers.You need to ensure that the account, SQL server is running under, has the appropriate access rights to the shared network partition. :). [EDIT] I'm not sure but I suppose that SQL server should better be running under Network service built-in account. [/EDIT]
Life is a stage and we are all actors!
modified on Tuesday, May 25, 2010 4:46 AM
-
Sometimes I have the same problem on some clients servers.You need to ensure that the account, SQL server is running under, has the appropriate access rights to the shared network partition. :). [EDIT] I'm not sure but I suppose that SQL server should better be running under Network service built-in account. [/EDIT]
Life is a stage and we are all actors!
modified on Tuesday, May 25, 2010 4:46 AM
Hristo Bojilov wrote:
I'm not sure but I suppose that SQL server should better be running under Network service built-in account.
I believe that is the problem. I had an issue where the account running the SQL Server Agent did not have the permissions to access the other server. I changed the account but I think there is a way to impersonate for a run. Sorry I have not used this but seem to remember reading in a study guide.
-
Hristo Bojilov wrote:
I'm not sure but I suppose that SQL server should better be running under Network service built-in account.
I believe that is the problem. I had an issue where the account running the SQL Server Agent did not have the permissions to access the other server. I changed the account but I think there is a way to impersonate for a run. Sorry I have not used this but seem to remember reading in a study guide.
still not get any appropriate answer.. Kindly add some more solutions.
-
Please understand i want to take backup's on some other server, not on the local.
Instead path of localhost give path in which you are trying to backup database.
I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com
-
Instead path of localhost give path in which you are trying to backup database.
I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com
That's what i am doing dear! See the BACKUP DATABASE [Outbound_Vodafone] TO DISK = N'\\dataserver\Database\Outbound_VodafoneDifferential_9PM.bak' WITH DIFFERENTIAL , INIT but it's not working.