December 1, 2010 at 6:30 am
hi pradeep
the path is not accessible for me.
in start and run also it is not accessing..
and in public network shared folder is not accessing..
if i give normal folder in d drive etc.. it is also not accessing..
what i have to do?
December 1, 2010 at 6:38 am
You need to have permissions on the folder. You can grant permissions to your account/the account with which the SQL Server is starting, as in this screenshot.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
December 1, 2010 at 6:45 am
actually system A is in LAN and system B is in public network..
is it possible to access a folder in system B from system A?
December 2, 2010 at 10:18 pm
hi pradeep
is there any other way?
i have to take backup of database in public network system..
that backup file should be in my system..i.e local network system.
share folder is not accessing..
so is there any other way?
December 2, 2010 at 10:23 pm
Hi,
Take the backup of the Public Network database locally on that server. Then you can move it your local drive. Unless you have access to the path where backup is located, it cannot be copied to your local server.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
December 2, 2010 at 11:30 pm
i don't want to move backup file manually..
is there any other way?
December 3, 2010 at 1:35 am
Like I said earlier, till one has access to the folder no file can be copied including backup files. There is no way to do it
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
December 20, 2010 at 5:41 am
hi .. pradeep..
can we take backup of public IP system..
December 20, 2010 at 5:44 am
vinayak.v (12/20/2010)
hi .. pradeep..can we take backup of public IP system..
You can take the backup of any database onto any location provided you have requisite permissions on the SQL Server instance and the backup path.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
December 20, 2010 at 6:05 am
thanks for reply..
normally for local system i.e network system
i've remotly connected to the database. into my system
i wrote the following command
backup database employee to disk = '\\MYSYSIP\backup\back.bak'
but for public ip wat to write
i'm getting the error
Cannot open backup device '\\MYSYSIP\backup\aaaaa.bak'. Operating system error 53(The network path was not found.).
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally...
December 20, 2010 at 6:34 am
From the error message it seems that the network path is not accessible from the source path.
Check if "\\MYIP\" is accessible from the Server hosting the SQL Server instance. If it is accessible to your account check if the SQL Server startup account has privileges on the share.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
December 20, 2010 at 9:07 pm
hi.. pradeep..
sorry for late reply
the server is in public network and how can i access
that public network.. and store the database into my system.
December 20, 2010 at 9:25 pm
the server is in public network and how can i access
that public network.
Try opening the server in "public network" in Windows Explorer. If it does not, then there may be restrictions on the server from which you are trying to access, which prevent access to servers outside the domain. You need to get in touch with your Windows Admins or the Firewall team.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
December 20, 2010 at 10:15 pm
how to open the server in public..
and i can also login remotely..
i.e remote desktop connection
February 4, 2013 at 6:53 am
Thanks alot
its working fine wit ha local server
but if I have a network SQL Server 2008, a make this script working in a lan.
please help me
Viewing 15 posts - 16 through 29 (of 29 total)
You must be logged in to reply to this topic. Login to reply