Viewing 6 posts - 1 through 6 (of 6 total)
Running SQL Server 2012 and 2019 on Windows Server 2016.
Backup file name is ACCOUNTING_backup_2019_11_20_180003_1654318.bak
Not sure how to pull that name from sys tables.
November 21, 2019 at 4:37 pm
Absolutely, I'm running it as myself, I'm the DBA and basically have sa permissions.
Did you see the backup file name that it is coming up with?
{3E74E0E1-1273-426E-B8E4-20E14E1C6992}2
November 21, 2019 at 4:03 pm
Tried this on both 2012 and 2019 get the same error.
-- 1. GET LATEST BACKUP FILE FOR A DATABASE--
{3E74E0E1-1273-426E-B8E4-20E14E1C6992}2
-- 2. CREATE DATABASE NAME TO RESTORE --
Accounting_November212019
-- 3. CHECK FREE DISKSPACE...
November 21, 2019 at 3:18 pm
In your example there is a typo
exec dba_CopyLogins @ParnterServer = 'PrimaryReplica'
Should be
exec dba_CopyLogins @PartnerServer = 'PrimaryReplica'
March 12, 2019 at 12:44 pm
Nice code.
Be good to point out that it only works only on complete column values not partial.
Also I have one enhancement.
It didn't work on one...
April 28, 2017 at 9:45 am
Awesome code, thanks for sharing!
Game over. Human player wins in 33 shots!
January 8, 2016 at 10:29 am
Viewing 6 posts - 1 through 6 (of 6 total)