Posts
Sort by recent activity
sql response - can it cause a system to halt?
We started having a problem on 3/19 - our production server was halting.
Initially this appeared in the Event log as a series of cascading MSMQ failures caused by a login failure from a remote serv...
PROBLEM with the comparison key
I have two databases on different servers. One is a staging server where updates from the source are applied. The other is a target server, where updates to the staging server need to be applied....
upgrade problem?
I saw the icon to update server components, but when I click on it, I get the following message, that makes no sense to me...
The current version of the server components is not the same as the ver...
RESTORE msdb FROM FULL BACKUP... HOW?
I am trying to restore msdb from a full backup taken last night.
I have turned off SQL Agent.
Yet, I continue to get this error when trying to restore...
WHALEY07: Restore - Failed
================...
How to create VDITimeout entry in registry?
Got this message in a warning..."or try increasing the value of the VDITimeout registry setting in HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\[InstanceName]"
Went into the...
LOG SHIPPING WIZARD - why do I have to explcitly include ...
Well - This is bizarre.
I have 4 copies of SQL Backup running on 4 standalone servers.
Each uses the following account for the Agent service and the MSSQL service <domain>/SQLBackup.
This account i...
use log shipping to populate a 'data mart'?
Hello -
I'm wondering about whether anyone uses SQL Backup Log Shipping to populate a 'data mart' and whether you find this advisable.
In reading about log shipping and putting the 'standby databas...
Why aren't deadlocks showing up in history?
Hello -
I thought I was being told that on average there is one deadlock in the morning on my server. However, due to some performance complaints, I started going back using the history view and f...
GUI Problem? (shows backups successful - with warnings)
Hi -
All of a sudden I'm seeing that all backups on a particular database are 'sucessful - with warnings'; yet the emails coming to me about those backups are all marked 'successful'. :shock:
Whic...
SQL Prompt - Unable to show database objects
Don't know what to do about this (i.e., how do I fix it?)
SQL Prompt cannot retrieve objects from <snip>. Possible reasons:
- insufficient memory to cache objects
- invalid permissions for this da...