I am using SQL server 2008. I have two servers and one instance per server.
Server1 is the principal and server2 is the mirror.
I do not use a witness server.
Now my mirror server must go down for 8 hours due to maintenance of the dataroom where the server stands.
Is there a way to put it on hold without losing my mirror or should i break the mirroring ?
Should i place my server is asynchronous mode ?
I understand either which mode i put my databases in the log at the principal just keeps growing ?
Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat. The purpose of this eBook is to educate the reader about ransomware attacks.
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted? Many believe this is the case.
Let us try to examine for ourselves with an example.
To get started, use the following script, wh…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder. The folder can be on the local hard drive or on a network share. This batch file will query the SQL server to get the current date & time and wi…
The Email Laundry PDF encryption service allows companies to send confidential encrypted emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…