Viewing 15 posts - 1 through 15 (of 32 total)
350GB - Wife's PC
50GB - My Laptop
3TB RAID 1 on VMWare host
2.5TB Backup server
January 27, 2007 at 11:35 am
We use TSM and TDP (the Tivoli Data Protection) module that backs up SQL databases directly using the native backup command and virtual devices. There was a problem with the...
March 3, 2004 at 7:54 pm
Check the SQL Server log to see if it was able to bind to the TCP/IP port. Sometimes when the server is re-booted, SQL will come up on shared memory...
March 2, 2004 at 4:48 am
I also chose the 'incorrect' answer. Since I usually am restoring the databse to another name, or even another server, I rarely have the luxury of using EM for the...
February 26, 2004 at 5:58 pm
You can also register it by full dns name. Which might be a better solution as you want your application developers to use DNS names to connect rather than...
December 18, 2003 at 6:26 am
I have seen this every once in a while on our larger databases. It appears that the log will only autoextend about 255 times during a single transaction before...
August 28, 2003 at 7:42 pm
AND (T1.STATUS_FLAG + T1.TIME_STAMP) IN (SELECT ST1.STATUS_FLAG + ST1.TIME_STAMP
With correct convert functions around the columns to convert them to varchar.
August 3, 2003 at 12:53 pm
We got around the problem on one major system by selling the idea of clustered servers. Development/QA runs on the backup node (named instance) and cannot fail over to...
June 26, 2003 at 9:40 pm
We have use both comdisco and sunguard. We were not happy with either and are now looking at in-house DR where we just rent some space from somone.
June 26, 2003 at 9:34 pm
I usually change the SID in sysusers to x01 for the dbo name because it is usually the SID of the user that created the db in the first place....
June 26, 2003 at 9:30 pm
We have 39 servers running 42 instances. We have over 600 databases. There are three clustered servers. There is one full time DBA, one junior DBA and the manager...
June 5, 2003 at 7:25 am
It sure sounds like Slammer, but you have SP3 already applied. Have you looked at the traffic with an analyzer to see where the data is going? That...
June 5, 2003 at 7:16 am
While it is true you can stop the service manually (without going through cluster services), there is the possibliity that the node will lock up, hold all the disk resouces,...
May 27, 2003 at 6:32 am
We have SQL Server running on Compaq DL580, Dell 6450 and IBM 335x boxes. The Dell was 4x700 with 2K cache, then DL580 is 4x700 with 1K cache and...
April 29, 2003 at 6:32 am
A trick we use to speed up backups over a LAN connection is to backup to multiple files. I have found for our network that eight files is the...
March 13, 2003 at 6:18 am
Viewing 15 posts - 1 through 15 (of 32 total)