How to backup all SQL Server DB to shared network drive daily ?

Senior IT System Engineer
Senior IT System Engineer used Ask the Experts™
on
People,

I have Microsoft SQL Server 2012 Standard Edition (64-bit) (SP2) - 11.0.5343.0 single DB instance (default MSSQLSERVER) with about 15 DB running in it.

How can I perform nightly SQL Server backup to the other server using UNC path ?

\\Backupserver\SharedFolder\SQL

Which permission do I need to grant ?

Thanks.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Administrator
Top Expert 2005
Commented:
Take a look at the link below for instructions on how to backup to a network drive.

https://www.mssqltips.com/sqlservertip/3499/make-network-path-visible-for-sql-server-backup-and-restore-in-ssms/
Jose TorresCertified Database Administrator
Commented:
My personal thoughts.
Unless I have no choice (i.e., gun to my head) I generally avoid backing up to shared drives....
To all other members that's just me and my personal preference.

That being said the quickest and easiest way is to create a maintenance plan
Make sure SQL Server Service is running using an AD account then make sure that account has access to the share.

Sorry forgot.
The maintenance plan select all the databases you want
For folder it will accept the UNC \\<ServerName>\<FolderName>

Author

Commented:
Hi,

The current SQL Server (MSSQLSERVER) service is running using the NT Service\MSSQLSERVER account by default.

So can I just grant the Computer AD account where the SQL Server running with full permission on both Shared & NTFS permission ?
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
OK,ih ave set it up working now but how can I enable the email alerting ?

I've created operator as myself but when I click on the send email alert I got this error:

---------------------------
Windows Internet Explorer
---------------------------
Could not perform this operation because the default mail client is not properly installed.
---------------------------
OK  
---------------------------
Jose TorresCertified Database Administrator

Commented:
Is dbmail setup

Author

Commented:
How to check it ?

I prefer not to install MS office in a DB server.
Jose TorresCertified Database Administrator
Commented:
Database Mail is part of SQL Server
Database Mail

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial