Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Back up to other server .. not in path Expand / Collapse
Author
Message
Posted Friday, November 2, 2012 7:48 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, March 2, 2014 1:41 PM
Points: 18, Visits: 37
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
Posted Friday, November 2, 2012 7:52 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 6:52 AM
Points: 5,131, Visits: 4,918
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
Posted Friday, November 2, 2012 9:37 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 5:30 PM
Points: 33,055, Visits: 15,167
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
Posted Friday, November 2, 2012 10:10 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, March 2, 2014 1:41 PM
Points: 18, Visits: 37
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
Posted Friday, November 2, 2012 11:10 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 6:52 AM
Points: 5,131, Visits: 4,918
You need to ensure that the account running the SQL server service has access to write to the unc path



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 #1380519
Posted Friday, November 2, 2012 6:04 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, March 2, 2014 1:41 PM
Points: 18, Visits: 37
DOH! Really (as in silly me)

Thanks!
Post #1380645
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse