Skip to content

SQL Jana

Jana's ramblings on SQL Server, Oracle, PowerShell and technology

Tag: NET USE

SQL Server: Backup/Restore to/from NAS Shares with Username/Password

Traditional Permanent NAS Share We setup NAS shares all the time for SQL Server backups and the procedure is quite simple. Find the SQL Server Engine Service account Grant full-control privileges to the share for the account Restart the SQL Server Engine Service for permissions to take effect (if needed) #Get the service account name(s). … Continue reading SQL Server: Backup/Restore to/from NAS Shares with Username/Password

Posted on October 28, 2022October 28, 2022 by SQLJanaPosted in Backup, NAS Share, SQL ServerTagged Access, Backup, dbatools, Generate TSQL, NAS, NET USE, Network, Password, Persist, Restore, Service Account, Share, SQL Server, SQL Service Account, SQLServer, UNC, UNC Path, UserName, xp_cmdshell. 1 Comment

Categories

Enter your email address to follow this blog and receive notifications of new posts by email.

Follow SQL Jana on WordPress.com

Tags

Active Directory AD Add AD Group Backup Backups Capture Code Column CommandLine COMMIT Compare COPY Database DateTime Days DBA dbatools DDL Delete DML Duration Dynamic SQL Error Errors Example Examples Fast File Files Filter FULL TABLE SCAN hangs Indexes INSERT Install ISE Linked Server Login LOOP Match Oracle Oracle Tip Output Parallel Performance Permissions PIVOT PLSQL PowerShell Query Replace ROLLBACK Run Search SELECT Size SQL SQL*Plus SQLPS SQL Server SQLServer SQL Server Tip SSMS Stored Procedure Table Tables Tip Transaction TSQL UNDO Update Usage USER Windows

Recent Posts

  • PowerShell & SQL Server: Unmask All Masked Columns (Dynamic Data Masking) In Database March 16, 2023
  • PowerShell: How To Reverse Alphabetical File Names & Rename December 17, 2022
  • SQL Server: Disable/Remove Indexes Across Servers/Databases Using PowerShell & dbatools November 9, 2022
  • MySQL: Fix MySQL Error 2026 (HY000): SSL connection error: error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol November 8, 2022
  • SQL Server: Backup/Restore to/from NAS Shares with Username/Password October 28, 2022

Top Posts & Pages

  • SQL Server: Fix: Transaction (Process ID) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction
  • Oracle: Find The Total Size Of All Of Your CLOB & BLOB Columns In All Tables
  • Oracle - CLOB vs. VARCHAR2 - When & When Not To Use?
  • PowerShell Tip: Specify Select Column List (Attributes/Properties) Dynamically
  • How to Resolve - "ORA-24381: error(s) in array DML"
  • Oracle - My KILL'ed Session Continues To Stay On In KILLED Status, Why?
  • SQL Server: SSMS Says "Lock request time out period exceeded." - Identify Blocking Source Quickly
  • SQL Server - Drop An User In All Databases & Drop The Login Too!
  • Hard-coding Values In SQL Code - Please Don't
  • Oracle - Return SELECT Statement Results Like SQL Server SP's - Using Pipelined Functions

Archives

  • March 2023 (1)
  • December 2022 (1)
  • November 2022 (2)
  • October 2022 (1)
  • April 2022 (1)
  • April 2021 (1)
  • November 2020 (1)
  • October 2020 (2)
  • September 2020 (1)
  • June 2020 (1)
  • May 2020 (2)
  • April 2020 (1)
  • March 2020 (2)
  • February 2020 (2)
  • November 2019 (1)
  • September 2019 (1)
  • July 2019 (2)
  • April 2019 (1)
  • March 2019 (3)
  • February 2019 (1)
  • November 2018 (1)
  • September 2018 (1)
  • August 2018 (1)
  • April 2018 (5)
  • March 2018 (3)
  • February 2018 (5)
  • January 2018 (6)
  • December 2017 (1)
  • October 2017 (1)
  • September 2017 (2)
  • August 2017 (4)
  • July 2017 (2)
  • June 2017 (3)
  • May 2017 (1)
  • April 2017 (11)
  • March 2017 (14)
  • February 2017 (23)
  • January 2017 (31)
  • December 2016 (10)
  • November 2016 (1)
  • October 2016 (3)
  • April 2016 (1)
  • March 2016 (1)
  • January 2016 (1)
  • November 2015 (2)
  • October 2015 (3)
  • September 2015 (1)
  • August 2015 (4)
  • July 2015 (1)
  • April 2015 (1)
  • December 2014 (1)
  • March 2014 (6)
  • February 2014 (1)
  • August 2012 (3)
  • October 2011 (1)
  • March 2011 (1)
  • February 2011 (1)
  • January 2011 (2)
  • December 2010 (2)

Follow me on Twitter

My Tweets
Create a free website or blog at WordPress.com.
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Follow Following
    • SQL Jana
    • Join 145 other followers
    • Already have a WordPress.com account? Log in now.
    • SQL Jana
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar