Activity overview
Latest activity by blakedba
Log Shipping Restore Stopping
Hello,
I have a Sql job that runs every Tues and Fri at 1:05 AM and does the following.
Set recovery to Bulk
DBCC DBREINDEX
DBCC UPDATEUSAGE
DBCC CHECKCATALOG
DBCC CHECHCONSTRAINTS
DBCC CHECKDB
sp...
Simple Recovery and Log Shipping
I have logshiping running from 6am - 11pm and a scheduled backup of production database running @ 10pm nightly.
Due to the activity of our database we need to run REINDEX a couple of times a week (...
Logshipping to server on seperate workgroup/Domain
Is it possible to logship files to SQL Server on different workgroup or domain on same network? We are considering setting up our disaster environment on a seperate workgroup
Thanks
It seems to be related to.. http://www.red-gate.com/support/kb/KB200708000117.htm
Also we run reindex/checkdb/update statistics. - this was run that day. We were getting low virtual memory and have since added another virtual pagefile.
From what I discoved on microsoft this error is related to running extended stored Proc/Large number of updateble DB's (not our case)
We are running W2003 SQL2000sp4 max memory for standard addition.
Thanks in advance / comments
It seems to be related to..http://www.red-gate.com/support/kb/KB200708000117.htm
Also we run reindex/checkdb/update statistics. - this was run that day. We were getting low virtual memory and have ...
WARNING: Failed to reserve contiguous memory of Size= 52166
Hi,
I have been getting this error ever since installing SlqBackup. Does anyone know if this is related or just coincidence?
Thanks
Log Shipping without initial Full Backup
Due to bandwith issues, I set up a seperate full backup and restore to our disaster database(READ ONLY). I tried using the GUI Log shipping with overwrite existing database...looks like it does a f...