Viewing 15 posts - 16 through 30 (of 984 total)
Yup, as long as you pass @with_copy = 1 as one of the parameters, it should do just that.
As always, though - test it before you break anything!
Good luck.
January 27, 2020 at 2:22 pm
Going by the documentation, when you restore a stretch database, you have to reauthenticate / reauthorise the access to the stretched data. One of the parameters to the command that...
January 27, 2020 at 2:00 pm
A couple of thoughts...
January 15, 2020 at 9:34 am
Happy New Year
May your late-night emergency call-out bleepers be kind to you this year.
I'm back in the office after the festivities. Nothing seems to have changed, except I think the...
January 2, 2020 at 12:05 pm
Are there lots of foreign keys? Triggers? indexed / materialized views?
December 17, 2019 at 1:11 pm
The latest documentation about this setting is at https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-min-memory-per-query-server-configuration-option?view=sql-server-ver15
Includes the warning "could lead to increased competition for memory resources"
Is your system very busy? I assume it is, otherwise...
November 19, 2019 at 12:31 pm
Yes, you can do it using something like VirtualBox on your PC - but you'll need to have plenty of RAM and spare disk space. There are various tutorials...
November 11, 2019 at 2:58 pm
From the documentation:
SQL Server might allocate more memory than the value specified in the max server memory setting. This behavior may occur when the Total Server Memory (KB) value has already reached...
November 11, 2019 at 12:18 pm
What was your answer? Do you know why it was wrong?
What's the job? (I assume it's a job interview you failed...)
November 6, 2019 at 9:02 am
The problem with using the social security number as a "natural" unique ID is that, erm, it isn't.
October 15, 2019 at 1:17 pm
This could be also a side-effect of what's called "Lazy Logging" in Availability Groups - there are lots of articles thrown up by a search - https://www.google.com/search?q=availability+group+lazy+logging
I would...
October 9, 2019 at 1:07 pm
SQL Saturday in Edinburgh - 1st Feb, anybody from here thinking about going?
I would do, except I'm playing in a show all that week. Bad timing...
October 7, 2019 at 7:30 am
You could look at using "SET NOEXEC ON" if you detect that you're in the wrong DB. That'll stop any further code from being executed in the batch (unless one...
August 7, 2019 at 9:28 am
Msg 5901, Level 16, State 1, Line 1
One or more recovery units belonging to database 'master' failed to generate a checkpoint. This is typically caused by lack of system...
August 2, 2019 at 11:45 am
Is backup compression enabled on the SQL 2016 server?
July 29, 2019 at 9:47 am
Viewing 15 posts - 16 through 30 (of 984 total)