Not sure if this helps, I've had some similar issues communicating between Oracle and SQL. I fixed them by using an Oracle product - Oracle Gateway - to link Oracle...

Yes - of the 12G a little data is held as tabular data but most of the data is mostly filestream. There are 4000 files - typical size is 25K...

Thanks for your interest.

Let me clarify

I have 2 databases - one with filestream objects needs 30 minutes to back up - this is the same amount of time as a...

you can use set rowcount but there a lot of conditions -

http://msdn.microsoft.com/en-us/library/ms188774.aspx

best use where clause...

How about if the VM was restored from a snapshot but only some disks were included in the snapshot?

So SQL is on the C drive which is in a snapshot,...

Hi

How about:

select * from INFORMATION_SCHEMA.columns

where TABLE_NAME = 'T1' and IS_NULLABLE = 'YES'

Do you already have a database called 'NiAccdb11' on the server?

You could use with replace on the restore or restore the dataabse to a new name.

If you have to, you should be able to put the data/logs/tempdb files onto separate luns on your VM (Or maybe your SAN admin or VM admin can do so?).

I...

Not sure if I fully understand, but some ideas...

I understand that you have full transaction logs. Are you performing transaction log backups?

Apart from SQL, are there any other processes running...

Why don't you have a backup? Our Network people take disk images - you may be able to get something off there if you have a similar environment. Read up...

Thanks - think I've fixed it.

I deleted all the cache files (on my server in C:\Users\SQL2K8AGENTService\AppData\Local\Temp).

Re-started the data collector and its been working for the past hour.

I suspect that this...

If its all working OK why change them? Changing could put you in a much worse position than you are now. If you have to change them, what fallback do...

Do you have blocking issues?

If so, how do you know that you do? what symptons/problems do you have?

Monitoring blocking may be expensive in resources etc; a performance issue could...

Glad to help - this took me a long time to fix.:-)

Which version od SQL Server?

I had a 32-bit SQL instance on 64-bit windows, and could not see the performance counters.

Until I ran \WINDOWS\SysWOW64\perfmon.exe - all counters appeared...