Viewing 15 posts - 16 through 30 (of 146 total)
Maddave I'm curious about this issue you saw. I would expect that an entry wouldn't be written to backupset until the backup actually completed? Or was SBE "forging"...
February 4, 2016 at 7:49 am
Even robust third party tools like Symantec Backup Exec get it wrong. We used Symantec to do our SQL Backups at one point but found it would mark the...
February 4, 2016 at 6:29 am
To be honest, I really cant remember. Usually a restart of the service will do for these things, but it may be worth bouncing the box too. Sorry I...
January 28, 2016 at 1:58 am
I found that using a managed service account, to get this working, the delegation needed to be setup a bit differently:
"If using a managed service account, set the delegation up...
January 27, 2016 at 10:14 am
I would recommend Redgates SQL Compare tools. Very easy and quick to use. You can download a 14 day trial.
December 17, 2015 at 9:58 am
Thank you both. That's what I found when I ran a test, but couldn't understand why you could specify a STOP AT with a diff restore. You've explained that,...
November 12, 2015 at 5:59 am
Not sure if this applies in you case, but SA also gives you mobility rights. If you have the VM running on one physical host and wish to move it...
November 2, 2015 at 7:21 am
SQLNCLI11 is only compatible back to SQL 2005. You could try creating a linked server using and ODBC data source and use the DSN in the linked server with...
October 29, 2015 at 10:39 am
If the passwords change, then the SQL Services will have to be restarted taking the instance offline.
Maybe look at Managed Service Accounts. We run our 2012 instances using these. No...
October 29, 2015 at 10:36 am
You can issue the command xp_cmdshell 'whoami.exe' to see what security context the command is being executed as.
October 1, 2015 at 7:31 am
As with most SAN implementations, I try to split out the log, data, temp and application files to different drives, even though they may reside on the same disk at...
September 1, 2015 at 5:03 am
Although it wont give you the network stats you may want, using sp_whoisactive will give you the percentage complete to a few decimal places. You may be able to determine...
August 19, 2015 at 2:30 am
Is the client IP address not part of the error in the SQL Log?
July 20, 2015 at 9:16 am
I dont think it will have any impact on performance, but option two would be better in terms of maintenance and clarity as it is more specific. It will...
July 1, 2015 at 6:47 am
Jeff Moden (6/22/2015)
Yowch. £6000 is almost $10,000USD. That's just crazy.
Sorry, I made a mistake. Just checked the last quote we had and the price is $3,795 per instance....
June 23, 2015 at 2:19 am
Viewing 15 posts - 16 through 30 (of 146 total)