Is the machine a multi-CPU AMD-based server? If so then the memory for these is arranged in banks, one bank per CPU (as in physical CPU, not per...
Hi all, I installed a second instance of SQL 2000 Enterprise onto our Windows 2003 Enterprise server last week to run as a dedicated instance for...
If Server B isn't permenantly connected to any storage where the databases are then you'll be looking at a fair amount of time to configure the SQL...
Hi all, Looking for a stored procedure that will kill SPIDs in a specified database. I keep seeing links to usp_KillUsers.sql on www.admin911.com...
Just to clarify the testing, the sequence of events ran thus: - added a record to the "Territories" table in Northwind - did a BACKUP LOG Northwind...
OK I've done some more testing. The command to restore the logs to the secondary server when there are multiple log backups in the file is this:...
Hi all, We have a pretty basic, home-grown log shipping setup. Until now, if for some reason the secondary server is unable to apply the latest log...
Thanks thomas, I will look into that a bit more. Worth pointing out perhaps, when I was testing the statistics using an 80% ratio it actually took 2...
Hi all, I'm looking at ways of improving performance on our 200GB ERP database and one of the first things I noticed was that no reindexing or...
We hit the same problem running DBCC DBREINDEX against our 200GB ERP database.<br /><br />What we did was to place the DB into simple recovery mode...
Frank, The app is not supported on SQL 2005 but then again the app is about to go end of life in another month or two anyway and we're not in a...
All the tables in the DB belong to the schema "bmssa". The application is attempting to connect as the user "bmssa" and I'm logging in through Query...
Hi all, Just at the very beginning of looking at SQL 2005 here. I've copied our ERP database (minus most of the actual data) to our 2005 test...
Hi Satya, Thanks for the welcome and the speedy reply! I will do some reading when i get a chance, we've been having some problems with a non-MS...
Hi all, Just a quick one for my first post - if I apply a transaction log backup which has already been applied to the database, will the...
Separate names with a comma.
