Mapping a drive and backing up a SQL Server database?
sivanagamahesh
Posts: 3 New member
in SQL Search
We go down our SQL Server databases to NAS, and was interested on the off chance that it is conceivable to go down to a brief mapped drive, instead of the UNC way. I'm reaching a stopping point.
Utilizing New-PSDrive:
New-PSDrive - Name "Y" - PSProvider FileSystem - Root "\\NAS\Backups" - Scope Global - Persist
Test-Path "Y:\SQLDBA" <# returns True #>
<# Method 1 #>
sqlcmd - E - d ace - Q "Reinforcement DATABASE [SQLDBA] TO DISK = N'Y:\SQLDBA\SQLDBA.bak' WITH INIT" - b
<# Method 2 #>
Summon Sqlcmd - Database ace - Query "Reinforcement DATABASE [SQLDBA] TO DISK = N'Y:\SQLDBA\SQLDBA.bak' WITH INIT" - QueryTimeout 999999999 - verbose - ErrorAction Stop
Evacuate PSDrive "Y"
Utilizing net utilize:
net utilize Y: \\NAS\Backups/persistent:yes
<# Method 1 #>
sqlcmd - E - d ace - Q "Reinforcement DATABASE [SQLDBA] TO DISK = N'Y:\SQLDBA\SQLDBA.bak' WITH INIT" - b
<# Method 2 #>
Summon Sqlcmd - Database ace - Query "Reinforcement DATABASE [SQLDBA] TO DISK = N'Y:\SQLDBA\SQLDBA.bak' WITH INIT" - QueryTimeout 999999999 - verbose - ErrorAction Stop
net utilize Y:/erase
Either technique gets me a similar blunder:
Can't open reinforcement gadget 'Y:\SQLDBA\SQLDBA.bak'. Working framework mistake 3(The framework can't discover the way indicated.).
Is this conceivable?
Utilizing New-PSDrive:
New-PSDrive - Name "Y" - PSProvider FileSystem - Root "\\NAS\Backups" - Scope Global - Persist
Test-Path "Y:\SQLDBA" <# returns True #>
<# Method 1 #>
sqlcmd - E - d ace - Q "Reinforcement DATABASE [SQLDBA] TO DISK = N'Y:\SQLDBA\SQLDBA.bak' WITH INIT" - b
<# Method 2 #>
Summon Sqlcmd - Database ace - Query "Reinforcement DATABASE [SQLDBA] TO DISK = N'Y:\SQLDBA\SQLDBA.bak' WITH INIT" - QueryTimeout 999999999 - verbose - ErrorAction Stop
Evacuate PSDrive "Y"
Utilizing net utilize:
net utilize Y: \\NAS\Backups/persistent:yes
<# Method 1 #>
sqlcmd - E - d ace - Q "Reinforcement DATABASE [SQLDBA] TO DISK = N'Y:\SQLDBA\SQLDBA.bak' WITH INIT" - b
<# Method 2 #>
Summon Sqlcmd - Database ace - Query "Reinforcement DATABASE [SQLDBA] TO DISK = N'Y:\SQLDBA\SQLDBA.bak' WITH INIT" - QueryTimeout 999999999 - verbose - ErrorAction Stop
net utilize Y:/erase
Either technique gets me a similar blunder:
Can't open reinforcement gadget 'Y:\SQLDBA\SQLDBA.bak'. Working framework mistake 3(The framework can't discover the way indicated.).
Is this conceivable?