May 26, 2011 at 2:49 am
hi to all ,
can any one provide me the backup script or the process how to do so ,
sql server authentication from a remote system to the server using t-sql script.
let me explain i am setting in my office and my server is in data center
i usually get connected with the database by sql server authentication login.
when i am trying to take the backup it is troughing error.
thanks in advance
May 26, 2011 at 4:36 am
Are you the DBA? Generally DBA's have all the permission needed. So you can check if SQL Server service account have permission on the Remote server.
Your SQL authentication account have the permission to take the backup. If yes then you can.
Script I have given you can only need to change the path and location.
"More Green More Oxygen !! Plant a tree today"
May 26, 2011 at 4:42 am
actually i am able to take the backup when i am providing the path of drive which is in the server.
but when i am providing the my laptop hard disk path it is showing the error.
May 26, 2011 at 5:11 am
let me make it clear
1- is my windows server where all the website and database is been hosted and is live .
2 -is my laptop.
ok
1-
if i am taking full backup from my laptop of database
backup db to disk = '1-c-drive ' it is running successfully
as per example
here {1} means server drive path.
and
2-
backup db to disk = '2-C-drive 'it is throughing error
here {2} means laptop drive path.
May 26, 2011 at 5:32 am
Check that the account running the SQL server services has permission to read write the folder specified.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 27, 2011 at 1:08 am
that is the problem of SQL Server service account,give write rights on the user which one using for the SQL server service account,if you are taking backup on the shared folder then give writes on that shared folder
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
May 27, 2011 at 5:00 am
Ivan Mohapatra (5/26/2011)
let me make it clear1- is my windows server where all the website and database is been hosted and is live .
2 -is my laptop.
ok
1-
if i am taking full backup from my laptop of database
backup db to disk = '1-c-drive ' it is running successfully
as per example
here {1} means server drive path.
and
2-
backup db to disk = '2-C-drive 'it is throughing error
here {2} means laptop drive path.
From a query window connected to the server, only the drives on the server are accessible.
You may be running SSMS from your laptop, but you're effectively on the server.
May 27, 2011 at 7:59 am
follow that Syed Jahanzaib said! is necessary to attribute the permissions to account service in folders out of database server!
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply