Multiple Backups from multiple instances

Question

Multiple Backups from multiple instances

Kris-155042

Hall of Fame

Points: 3460
More actions
September 3, 2004 at 1:51 am

#85243

I have recently got a new SQL server which I have installed around 35 databases on 5 different instances. I want the backups to go to another server as they were previously but it seems that the backups only work for the instances that are on port 1433. None of the others work.

HEEELLLPPPP!!!
Thanks,
Kris

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Ray Mond SSCertifiable Points: 7159 More actions · Answer 1

Could you pls post the error messages you are receiving?

SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.

Kris-155042 Hall of Fame Points: 3460 More actions · Answer 2

Yep!

"The backup directory is invalid. Are you sure that is what you want?"

Thanks,

Kris

Ray Mond SSCertifiable Points: 7159 More actions · Answer 3

I take it you are trying to backup to a remote folder, and that you are encountering errors when trying to perform the backup? Ensure that the SQL Server service startup account has rights to those remote folders (LocalSystem will not work).

SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.

Kris-155042 Hall of Fame Points: 3460 More actions · Answer 4

I'm trying to set up a maintenance plan. The start up account has full access to the remote server. I can't see the difference between the previous server which worked and this one.

Thanks,

Kris

Ray Mond SSCertifiable Points: 7159 More actions · Answer 5

Have you tried performing a backup using Query Analyzer first, to the remote destination folders?

SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.

Kris-155042 Hall of Fame Points: 3460 More actions · Answer 6

I've tried backing up manually and it still doesn 't work. I thought it might be the script so I ran it on a server that does backup properly and the script worked.

Thanks,

Kris

Ray Mond SSCertifiable Points: 7159 More actions · Answer 7

If it even fails when running manually, I think there is definitely something wrong with the remote folder permissions. See if you can query the contents of the remote folders from within Query Analyzer, using something like this:

master..xp_cmdshell 'dir \\remotefolderpath'

If that doesn't work, I suggest checking your SQL Server service startup account again.

SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.

Kris-155042 Hall of Fame Points: 3460 More actions · Answer 8

You're a legend. Server had set up permissions on the security section but not the actual permission for the SQL login.

Thanks, it works perfectly now

Thanks,

Kris