Back up to other server .. not in path

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Strategies » Back up to other server .. not in path

Back up to other server .. not in path

Rate Topic

Display Mode

Topic Options

Author

Message

britinusa

Posted Friday, November 02, 2012 7:48 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, April 18, 2013 10:56 AM
Points: 17, Visits: 30

We're in the process of migrating SQL 2000 to SQL 2005.

We're going to use the existing "box" that runs SQL 2000 as a temporary external back up device.

Slowly we are moving the data and log files over ...

Under Windows 7, we are able to easily copy files from one server to the other ... from SQL2000 to SQL2005 boxes. Thus the new server can "see" and copy from the old box to the new.

But when we want to start backing up (already) to the old box ... SQL2005 is not including in the pull down list (browse) anything but the local server.

No network option.

We right click on the given database, in the Destination list at bottom, we see a local folder; we click Add. then click on the elipses; and only see the local server.

What am I doing wrong?

Robert

Post #1380375

anthony.green

Posted Friday, November 02, 2012 7:52 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

You will need to manually create the backup command passing in the UNC path

Something like

BACKUP DATABASE database1 TO DISK = '\\SERVER\share\database1.bak'

You can manually type in the UNC path to the backup GUI, but the backup GUI cannot see anything other than the local drives of the SQL server.

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1380377

Steve Jones - SSC Editor

Posted Friday, November 02, 2012 9:37 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 11:20 AM
Points: 31,437, Visits: 13,752

Note that the service account running on the new server needs rights to get to the SQL 2000 server. Along with that, use Anthony's advice.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #1380460

britinusa

Posted Friday, November 02, 2012 10:10 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, April 18, 2013 10:56 AM
Points: 17, Visits: 30

Thanks for the reply ...

Tried manually entering the UNC. While windows explorer copies fine to the backup server, sql 2005 fails with an error ...

Error 5: Access denied.

Post #1380486

anthony.green

Posted Friday, November 02, 2012 11:10 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

You need to ensure that the account running the SQL server service has access to write to the unc path

Post #1380519

britinusa

Posted Friday, November 02, 2012 6:04 PM

Grasshopper

Group: General Forum Members
Last Login: Thursday, April 18, 2013 10:56 AM
Points: 17, Visits: 30

DOH! Really (as in silly me)

Thanks!

Post #1380645

« Prev Topic | Next Topic »

Permissions