Sql-server – Backup SQL Server 2017 to remote directory

backupsql serversql-server-2017

There is SQL Server instance with 4 DBs.
There is remote directory '\u12160.your-backup.com\backup\SQL' which can be accessed ONLY with User/Password (no user auth or anything other).

I want to backup DBs on schedule with SQL Server Agent job like this

EXEC sp_BackupDatabases @backupLocation='\\u12160.your-backup.com\backup\SQL', @backupType='F'

but it throws error

Operating system error 1326(The user name or password is incorrect.).
Msg 3013, Level 16, State 1, Line 1

Is it possible somehow to pass username/password? Or are there any other ways to backup straight into remote directory&

Thank you.

Best Answer

Can you turn the network path into a drive letter using windows explorer or workplace

This allows to "use different user credentials" - and "remember the settings" + "automatically connect upon startup"(or similarly named) - so it should automatically connect to the network path using the username+password combo you got... Then use your database backup with the created drive letter from the above step

Related Solutions

Sql-server – Backup SQL Server To NAS

Your syntax is wrong for adding a backup device.

When you create a backup device in SQL Server you are actually creating the "bak" file as a media set.

Along with the suggestion from Bob that you should be using the full UNC path, your syntax should be changed to something like this:

IF  EXISTS (SELECT name FROM master.dbo.sysdevices WHERE name = N'NAS_YEDEK_DB')
EXEC master.dbo.sp_dropdevice @logicalname = N'NAS_YEDEK_DB'
GO

EXEC master.dbo.sp_addumpdevice  @devtype = N'disk', @logicalname = N'NAS_YEDEK_DB', @physicalname = N'\\10.1.1.x\yedek_db\YEDEK_DB_backup.bak'
GO

Sql-server – SQL Server backup fails on disk space error

The error not enough server storage available is misleading. This is not disk space, but Windows SMB management memory. Try restarting the target machine (where the backup is being saved), or at least restart the Server service.

See the following Microsoft support link for instructions on potential registry changes that may be necessary at the machine where the backup is being stored.

http://support.microsoft.com/kb/304101

Also, you might try a search for "Windows Server error 1130" for more info.

Best Answer

Related Solutions

Sql-server – Backup SQL Server To NAS

Sql-server – SQL Server backup fails on disk space error

Related Question