SQL Server 2014. Send backup to a folder

Question

question

vivekchandra09 asked Nov 22, '16

SQL Server 2014. Send backup to a folder

folder: \\archive1\sql$\ArcGIS. How to do that?

sql server 2014 sql-server-2014 sql-server-2014-standard sql-backup

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2016-11-22T20:28:30Z

JohnM answered Nov 22, '16

For a very simple backup: BACKUP DATABASE [DatabaseName] TO DISK = '\\archive1\sql$\ArcGIS\DatabaseName.bak' The SQL Server Engine service account would need permissions to read/write to that particular directory. Reference: https://msdn.microsoft.com/en-us/library/ms186865.aspx Hope that helps!

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2016-11-22T20:28:49Z

sjimmo answered Nov 22, '16

You will have to make sure that account that SQL Server is operating as has permissions to write to the share/folder in question. Then create your script for the backup to occur, putting the path in the TO DISK portion of the code.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 3 · 2016-11-23T03:26:42Z

DazyParker answered Nov 23, '16

Hello Vivek, I agree with both answers. You have to check the permission first then, enter the path to disk portion of the code. Good Luck!

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 4 · 2016-11-28T01:52:25Z

vivekchandra09 answered Nov 28, '16

I was able to take backup to the url. My databases are in simple mode right now. Now I need to schedule the backup daily.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question