Viewing 15 posts - 451 through 465 (of 6,400 total)
Do you need to create the procedure in all DB's? Only some of the DBs? Do you need to change anything in the procedure definition dynamically also to match.
Please elaborate...
December 15, 2022 at 8:55 am
No your stuck with modifying the scripts I'm afraid.
The only thing would be install a named instance on the same server with the right collation and move the inconsistent DB...
December 9, 2022 at 9:20 am
Create the "report" user on the primary and give it the needed permissions to the databases in question.
Then go grab a copy of sp_help_revlogin from Microsoft's documentation and create this...
December 7, 2022 at 10:43 am
Use the same folder structure you get with your normal backups, it saves re-inventing the wheel for your backup to tape/off site methodology.
For cleanup again, set the log shipping cleanup...
December 7, 2022 at 9:08 am
1 - generally it is best practise to have a folder structure for each database and each type of backup
backups\master\full
backups\master\diff
backups\master\logs
ETC then you know what is what, especially with fulls and...
December 6, 2022 at 10:03 pm
What is your current log retention period in the maintenance plan? What is your current delete files older than setting? Set the log shipping clean-up older than to be the...
December 6, 2022 at 10:03 am
Do not disable anything created by the LogShipping setup process.
You need to put the needed exclusions into your existing Transaction Log Backup process to ensure it excludes the databases which...
December 6, 2022 at 9:46 am
Yes in those technologies all commands are synchronised as they take a full copy of the transaction log.
December 4, 2022 at 2:51 pm
If the disaster is in Site B yes the cluster will still stand.
Otherwise if site A goes offline then no the cluster is down.
You can have a look at changing...
December 3, 2022 at 10:52 pm
Wingdings is your best bet.
That or use an image and base the expression so show the image based on the Boolean value of the field.
but what is wrong with just...
December 3, 2022 at 10:47 pm
No update statistics do not get replicated either.
The only caveat to that would be when enough of the data has changed to kick off an AUTO UPDATE statistics background thread.
replication...
December 3, 2022 at 10:44 pm
Yes it works, differential backups are optional and are there for a convenience factor when you have loads of logs to restore really as it makes the restoration process easier.
How...
December 1, 2022 at 10:22 am
So do you need a listener is the question?
How many web.config files do you have to change?
What is your RTO?
What other servers/applications do you also need to look after in...
November 29, 2022 at 7:01 pm
What is a sample output of the following query?
Just want to see where SQL thinks the backups are actually going as if it’s going to a virtual device using VDI...
November 29, 2022 at 6:35 pm
Viewing 15 posts - 451 through 465 (of 6,400 total)