sql server new users: Express: Backup to local computer? -- sql server new users

Re: Express: Backup to local computer?

Ekrem_Önsoy
8/30/2007 12:00:00 AM

Hi Ralf,

Try using a UNC path.

For example: share a backup folder on your local computer's disk and name
its share name as "SQLBackups"

- To back up a database from the other computer connect to the Instance from
SQL Server Management Studio, expand the "Databases" node and select the
database to be backed up. Right click on it and choose "Tasks" and "Back
up..."
- In the "Back Up Database" window go to Destination panel which is in the
bottom of the window. If there is a path in the listbox remove it and click
"Add..." button.
- Type the file name as \\<your computer name>\SQLBackups\backup_test.bak

That's it.

--
Ekrem Önsoy

[quoted text, click to view]

Re: Express: Backup to local computer?

Ralf Kaiser
8/30/2007 12:00:00 AM

"Ekrem Önsoy" <ekrem@btegitim.com> schrieb im Newsbeitrag
news:106CCAFF-13A4-4EEF-8BB4-5DF245C70E0C@microsoft.com...
[quoted text, click to view]

Hello Ekrem,

i have tried that meanwhile but the problem is that the remote computer is
not part of our network (it is also a remote IP at our provider). So it does
not work. It seem that the remote server tries to find the UNC path inside
its own network and i get an error message that the path cannot be found.

Ciao,
Ralf

Re: Express: Backup to local computer?

Ekrem_Önsoy
8/30/2007 5:21:16 PM

Are you connected to that system via VPN? If not, what?

Are you able to you ping the remote SQL Server?

--
Ekrem Önsoy

[quoted text, click to view]

Re: Express: Backup to local computer?

Ralf Kaiser
8/31/2007 12:00:00 AM

"Ekrem Önsoy" <ekrem@btegitim.com> schrieb im Newsbeitrag
news:121768D0-3F0D-4638-860F-DB23DD71B531@microsoft.com...

Hi Ekrem,

[quoted text, click to view]

It is a normal IP connection. I connect with the remote server with the IP
address in SQL Server Management Studio like that:

"123.123.123.123\SQLEXPRESS"

[quoted text, click to view]

Yes of course.

Ciao,
Ralf

Re: Express: Backup to local computer?

Ekrem_Önsoy
8/31/2007 12:00:00 AM

If remote SQL Server is also able to ping you...

16.16.16.16 = is your computer in this scenario.

When you type the path as "\\16.16.16.16\MyBackups" to the remote SQL, what
error occurs? Could you check it from Event Viewer or SQL Server Logs?

Note:
BTW, you can not back up from a remote SQL Server to another machine if you
want to backup to a tape. Tape backups have to be local (tape machine have
to be connected to the SQL Server physically) This restriction is not valid
for HDD backup.

--
Ekrem Önsoy

[quoted text, click to view]

Re: Express: Backup to local computer?

Ekrem_Önsoy
8/31/2007 12:00:00 AM

Also, remote machine must have access to your computer and read\write
permissions to the backup folder that you create on yor computer for backup.

--
Ekrem Önsoy

[quoted text, click to view]

Re: Express: Backup to local computer?

Ralf Kaiser
8/31/2007 12:00:00 AM

"Ekrem Önsoy" <ekrem@btegitim.com> schrieb im Newsbeitrag
news:61D43B76-B894-424F-B97F-6198A3D74862@microsoft.com...
[quoted text, click to view]

Hi,

have not tried that yet but the access of the other machine to my machine
should be a problem, i think. I will try it as soon as possible.

Ciao,
Ralf

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server new users group.