Viewing 15 posts - 46 through 60 (of 67 total)
Turns out one of our consultants had taken a copy of the VM environment for a demonstration but had not considered the jobs that might be running before running it....
July 9, 2012 at 6:20 am
I know this topic is now OVER 2 years old but it's still very relative to a scenario I'm dealing with today.
I have a table, basically the following (reduced for...
June 8, 2012 at 5:50 am
Found it.
D:\Program Files (x86)\Microsoft SQL Server\MSSQL.2\MSSQL\LOG
I should have looked in the SQL Server properties, General tab and the Root Directory sooner.
Thanks anyway
Giles
February 15, 2012 at 9:43 am
Actually that's a very good point, it appears there is SQL Express on the server too and that was the log location for that.
The server I'm interested in the default...
February 15, 2012 at 9:34 am
Everyone, thank you so much.
As Henrico suggested, the SQL_Latin1_General_CP1_CI_AS collation worked perfectly, it did mean I had to go and rewrite a few SQL scripts, hence the delay in getting...
February 8, 2012 at 8:10 am
We're trying to determine if we can make audit_id a primary key which is why we're running the query.
The only thing I can think at this time is because the...
December 8, 2011 at 6:54 am
Of Course, Not Exists!
I'll give that a go as although 30 mins is acceptable if we can get it down then it's got to be worth the investigation.
Thanks
March 30, 2011 at 5:18 am
Just a quick note about the where clause you suggested.
AuditActivityName = 'Email Sent'
wouldn't work as I only want people whose ONLY activity was Email Sent. The Where clause is row...
March 30, 2011 at 5:02 am
Hello,
Sorry it's taken a while to get back with my results.
The revised index and the temp tables got the query down under half an hour, which in the environment is...
March 30, 2011 at 4:58 am
Thanks for your advice, my hand is forced on the UniqueIdentifier as it MSCRM I'm affraid.
The simpler suggestion you mention will only pull in those that have other activity other...
March 25, 2011 at 11:37 am
Good call, I've either been lazy, forgetful or both but I should have looked there earlier.
Found the event straight away and it is backing up to a virtual device.
Database backed...
March 3, 2011 at 10:21 am
Yes, the diff backup works fine following a full backup. Tthe problem is only if one of those 7168 sized backup has happened in between.
Their IT support say they've stopped...
March 3, 2011 at 8:20 am
Agreed, as soon as we found the issue we reverted back to full backups every day. The only issue is we need to keep a fortnights worth of backups...
March 3, 2011 at 7:46 am
Reposted on the SQL Server 2005 backup forum: http://qa.sqlservercentral.com/Forums/Topic1072550-357-1.aspx
March 3, 2011 at 7:32 am
Thanks Alex S, it's all so obvious now, only 1 table! I looked at the properties of the FT index in the other CRM databases and grabbed a screen shot...
January 28, 2011 at 2:53 am
Viewing 15 posts - 46 through 60 (of 67 total)