Refreshing Availability Group Database with PowerShell
Following last weeks post on Refreshing A Mirrored Database with PowerShell I thought I would write the script to refresh...
2014-09-04
1,620 reads
Following last weeks post on Refreshing A Mirrored Database with PowerShell I thought I would write the script to refresh...
2014-09-04
1,620 reads
SQL mirroring is a means of providing high availability for your SQL database. It is available in Standard Edition and...
2014-08-25
1,107 reads
I had an email last night from someone who attended my PowerShell Box of Tricks session at SQL Saturday Exeter
He...
2014-05-05
928 reads
A very short blog today just to pass on this little script.
I was required to list all of the SysAdmins...
2014-04-14
534 reads
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers