question

vivekchandra09 avatar image
vivekchandra09 asked

SQL Server 2014. Send backup to a folder

folder: \\archive1\sql$\ArcGIS. How to do that?
sql server 2014sql-server-2014sql-server-2014-standardsql-backup
10 |1200 characters needed characters left characters exceeded

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

JohnM avatar image
JohnM answered
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 characters needed characters left characters exceeded

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

sjimmo avatar image
sjimmo answered
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 characters needed characters left characters exceeded

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

DazyParker avatar image
DazyParker answered
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 characters needed characters left characters exceeded

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

vivekchandra09 avatar image
vivekchandra09 answered
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 characters needed characters left characters exceeded

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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