Comments
Sort by recent activity
My thoughts exactly
Ours is a heavy server load, but i should'nt be seeing redgate errors on their.
Is there way to turn this top query aspect off as it's something we don't use anyway?
Also the deadlocks fill my sql log so simply ignoring them is very difficult to do.
We could do with a quick fix for this please?
thanks / comments
My thoughts exactly
Ours is a heavy server load, but i should'nt be seeing redgate errors on their.
Is there way to turn this top query aspect off as it's something we don't use anyway?
Also the de...
Hi
I've solved this problem by following this article http://www.red-gate.com/supportcenter/C ... 000215.htm
thanks / comments
Hi
I've solved this problem by following this articlehttp://www.red-gate.com/supportcenter/C ... 000215.htm
thanks
i'm having exactly the same problem.
this cluster used to work fine for about 2 years and now suddenly won't work / comments
i'm having exactly the same problem.
this cluster used to work fine for about 2 years and now suddenly won't work
hi
all of the databases are online and working fine (this is a production server)
they are all showing as offline in sql monitor
this worked fine in 2.2
thanks / comments
hi
all of the databases are online and working fine (this is a production server)
they are all showing as offline in sql monitor
this worked fine in 2.2
thanks
Hi
Thanks for your prompt response.
In answer to your questions:
All of the times are the same time - from the domain controller.
All moniotred machines are all in the same physical location
There 4 SQL servers being monitored.
Yes SQL is monitoring its own database. Average Disk Read is 1.1ms, write 1.2ms. Transfer per sec = 2.3.
What type of disk is Sql Monitor's repository stored on? Generic answer is fine, e.g.:
it is a SAN / high performance RAID.
This has only happened once. I will keep an eye on it.
Thanks / comments
Hi
Thanks for your prompt response.
In answer to your questions:
All of the times are the same time - from the domain controller.
All moniotred machines are all in the same physical location
There ...
the problem i'm having is that it's returning an error code of 0 when it in facts fails. I'm trying to automate a restore process and if i can't get a negative error code when it fails then it's no use to me i'm afraid. I know why it fails i just need it to tell it me it fails when it does
When's version 4 coming out? / comments
the problem i'm having is that it's returning an error code of 0 when it in facts fails. I'm trying to automate a restore process and if i can't get a negative error code when it fails then it's n...
Hi Brain
To make the error occur just try and restore an incremental that's not in order.
I took the following processes:
1) Backup a full database on server 1
2) Restore the full database on server 2 leaving the db in read only with an undo file.
3) Create an incremental backup on server 1 after some data had been inserted (INC1)
4) Create another incremental backup on server 1, again after some data had been inserted (INC2)
5) Try and restore the second incremental backup (INC2) on server 2, leaving the database in readonly mode with an undo file.
Both the databases on each server are in simple recovery mode.
Let me know if you need any further information.
Jonny / comments
Hi Brain
To make the error occur just try and restore an incremental that's not in order.
I took the following processes:
1) Backup a full database on server 1
2) Restore the full database on serve...
Perfect.
Thank you / comments
Perfect.
Thank you