Viewing 15 posts - 1,006 through 1,020 (of 7,481 total)
You can do that using e.g. a scheduled task providing that wanted windows account as execution account of that task.
and then have that task execute the wanted sqlcmd using the...
December 3, 2015 at 5:36 am
Great feedback, guys ! :w00t:
Thanks.
December 3, 2015 at 5:27 am
to use Windows authentication use the parameter -E in stead of the -U and -pwd
December 3, 2015 at 5:24 am
first of all, you only have to install the most recent CU.
First install that CU at the non-active node.
the you will have downtime ! for failing over the SQLinstance from...
October 7, 2015 at 1:59 am
Database mirroring in use ?
With regards to Error 18456 I always use Aaron Bertrand's article: Troubleshooting Error 18456
October 6, 2015 at 3:28 am
tt-615680 (9/25/2015)
September 25, 2015 at 5:55 am
Set-location "c:\myfolder\SQLBackups"
# List all files and order by LastWriteTime descending
get-childitem -Filter '*.BAK' | Select FullName, LastWriteTime | sort LastWriteTime -Descending | ft -AutoSize
# only the most recent file
$Bakfile =...
September 24, 2015 at 2:01 am
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
Viewing 15 posts - 1,006 through 1,020 (of 7,481 total)