<div>
Hi,<br />
<br />
The current <b>SQL Server (MSSQLSERVER) </b>service is running using the <u>NT Service\MSSQLSERVER</u> account by default.<br />
<br />
So can I just grant the Computer AD account where the SQL Server running with full permission on both Shared &amp;&nbsp;NTFS permission ?
</div>


<div>
OK,ih ave set it up working now but how can I enable the email alerting ?<br />
<br />
I've created operator as myself but when I click on the send email alert I got this error:<br />
<br />
--------------------------<wbr />-<br />
Windows Internet Explorer<br />
--------------------------<wbr />-<br />
Could not perform this operation because the default mail client is not properly installed.<br />
--------------------------<wbr />-<br />
OK &nbsp; <br />
--------------------------<wbr />-
</div>


<div>
How to check it ?<br />
<br />
I prefer not to install MS office in a DB server.
</div>


<div>
<div class="content wysiwyg-content">
People,<br />
<br />
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.<br />
<br />
How can I perform nightly SQL Server backup to the other server using UNC path ?<br />
<br />
\\Backupserver\SharedFolde<wbr />r\SQL<br />
<br />
Which permission do I need to grant ?<br />
<br />
Thanks.
</div>
</div>


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.

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

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.