Creating a mssql database backup using odbc on mac

Question

So, MSSQL is nice enough to have given us a nifty little sql code for creating a database backup from a command line:

BACKUP DATABASE [db_name] TO  DISK = N'D:\backups\back.bak' WITH NOFORMAT, NOINIT,  NAME = N'db_name', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO

However, I am looking to be able to run this command from a php or even shell script on a remote Mac server.

The Problem I am running into is when I try to change the DISK to say my admin home directory, it keeps complaining to me about:

Cannot open backup device 'D:\PATH\ON\SERVER\/Users/admin/back.bak'. Operating system error 3(The system cannot find the path specified.).

Anyone know what I am missing here? I would be very appreciative

Joachim Isaksson · Accepted Answer · 2013-05-24 19:19:20Z

2

SQL Server's BACKUP command does a backup to the database server's local disk. That means that setting the path to a directory on the client machine makes no sense.

If you want a database backup stored on your client machine, I can basically see 3 options;

Back up to a temporary location accessible from the database server, and copy it from there to your client.
Mount a disk shared from your client machine on your database server as for example X:\ and do the backup to that disk.
Find another backup solution that does backups in a different way (sorry, no, I have no recommendations)

answered May 24, 2013 at 19:19

Joachim Isaksson

182k28 gold badges297 silver badges307 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

bobkingof12vs Over a year ago

Aw Man... All my hopes and dreams crushed... Thats okay. I found a way around this per your suggestion thank you

PolloZen · Accepted Answer · 2016-04-06 07:08:49Z

-1

You can use RasorSQL, it's a client for mac and windows. https://razorsql.com/

answered Apr 6, 2016 at 7:08

PolloZen

6626 silver badges12 bronze badges

1 Comment

Bob Arezina Over a year ago

this doesnt do .bak files on mac for microsoft sql server

Collectives™ on Stack Overflow

Creating a mssql database backup using odbc on mac

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related