Viewing 15 posts - 211 through 225 (of 9,244 total)
I have a 3 terabyte database that is taking over 5 hours to backup and restore. I'm utilizing multiple files to do the backup. We are on an Azure...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 23, 2024 at 3:47 pm
Hello,
Some months back we migrated an Azure SQL server off Azure and onto a private cloud. The Azure instance was subsequently deleted from within Azure. We've noticed that daily...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 23, 2024 at 3:45 pm
the DMK is part of the encryption hierarchy used to encrypt the sensitive data withn the database, it must be backed up and restored.
There are various logins provisioned into the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 23, 2024 at 3:36 pm
confirm you backed up and restored the DMK?
What other steps did you take to migrate the ssisdb?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 23, 2024 at 3:13 pm
when you migrated the ssisdb did you follow the procedure to obtain the DMK, there are various guides on how to do this and the other steps involved
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 23, 2024 at 3:04 pm
Have you checked the cluster logs, export them via Powershell and inspect them for any errors, this link details the Get-ClusterLog cmdlet
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 23, 2024 at 3:00 pm
it all depends on what data you wish to harvest and build the schema to match, there's no offering out of the box that i've seen
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 23, 2024 at 2:52 pm
many different ways of doing it using various cmdlets, had been trying get-volume and get-wmiobject, get-ciminstance seems to be preferred though, looking to make use of the sql table target...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 23, 2024 at 8:59 am
Whatever schema you want them to be
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 22, 2024 at 6:54 pm
Central Management Server
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 22, 2024 at 1:23 pm
I implemented a similar solution at work, logging the disk free space (along with database free space) to a table along with when it was recorded. Simple SSRS...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 22, 2024 at 7:39 am
Have you checked the cluster log for more detailed event information
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2023 at 2:13 pm
First question is why 50 dbs per AG, generally you want all application related dbs in a per application AG, are these sharepoint databases
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 14, 2023 at 10:01 pm
Is the group set synchronous or asynchronous mode
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 14, 2023 at 9:47 pm
Have there been any alter database actions on the primary?
do the primary and secondary instances have the same drive\path assignments
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 14, 2023 at 9:43 pm
Viewing 15 posts - 211 through 225 (of 9,244 total)