Viewing 15 posts - 1,021 through 1,035 (of 7,489 total)
It depends.
What's the recovery model used by the source database ?
What's the final goal of your database ?
Do you need your target database to be in e.g. read-only state, Read-Write...
September 23, 2015 at 6:48 am
SET Statistics time, io on
...
Set statistics time, io off
SELECT ...
INTO [TraceMMdd]
FROM ::fn_trace_gettable('E:\Thermo\MSSQL12.MSSQLSERVER\MSSQL\Log\ALZDBA_SQL_Trace_..._20150630_0838_.trc', default)
an off course The Glenn Berry Diagnostic...
August 21, 2015 at 9:17 am
Brandie Tarvin (7/30/2015)
...EDIT: Seriously, can anyone give me a real reason why WITH (NOLOCK) might be functionally necessary for production code?
To keep the answer brief and firm: No.
The risk encountering...
July 30, 2015 at 6:50 am
As you know with AlwaysOn it's the little things that really matter.
Don't just set it up, but test it to the max before you go live.
And that includes Backup and...
June 18, 2015 at 8:39 am
Perry Whittle (6/18/2015)
...It will never work in this configuration, you won't be able to enable the standalone instance for AlwaysOn when the node is not part of a WSFC.
It will...
June 18, 2015 at 6:54 am
GilaMonster (6/17/2015)
Alvin Ramard (6/17/2015)
GilaMonster (6/17/2015)
Please note: 10 year old post.Hopefully the OP isn't still looking for that procedure.
Hopefully the SQL 7 server has long since been relegated to the...
June 18, 2015 at 12:42 am
The big downside of using three part naming is during "same instance different DB-name recovery" !
This mostly happens to correct a mishap.
Hush hush repair may cause more damage due...
June 11, 2015 at 7:53 am
Could not find stored procedure 'Validate_User_Token'
Indeed, at least Schema qualify all objects !
Exec [YourSchema].Validate_User_Token
Accounts can have their own default schema set !
June 11, 2015 at 7:47 am
Solved the issue !
The trick lies in Set-ClusterOwnerNode and specify a Resource !
$Res = Get-ClusterResource -Cluster cl11 -Name "SQL Server ($InstanceName)" |
where ResourceType -eq...
April 30, 2015 at 6:16 am
I have this issue on our SQL2008R2 SP2 instance.
It just didn't register any deadlock data in system_health for the last 11 days ( and counting ).
To fix it I request...
March 17, 2015 at 2:53 am
Perry Whittle (2/11/2015)
ALZDBA (2/11/2015)
- You need to know the difference between Clustering and Always-on !My stairway series details this, has been linked and is available on this site
...
and a great...
February 11, 2015 at 4:36 am
I haven't read through the whole thead, but just want to share my 2ct
- You need to know the difference between Clustering and Always-on !
- clustering: HA solution...
February 11, 2015 at 4:18 am
I don't use maintenance plans because of different issues.
I use Backup devices for all sqlserver backups ( 3 devices per database ( Full / Diff / Log ) )
Diff...
February 11, 2015 at 4:06 am
No worries ! There are more ways to skin a cat 😉
Off course an "alter database [x] set offline with rollback immediate" is the most safe way.
Seems strange:
Or the db...
February 10, 2015 at 5:58 am
I always put the target database offline ( with rollback immediate ) right before the actual restore statement, to be sure no one blocks my restore.
I have incorporated it all...
February 10, 2015 at 5:21 am
Viewing 15 posts - 1,021 through 1,035 (of 7,489 total)