Forum Replies Created

Viewing 15 posts - 1 through 15 (of 32 total)

  • RE: Data At Home

    350GB - Wife's PC

    50GB - My Laptop

    3TB RAID 1 on VMWare host

    2.5TB Backup server

  • RE: Hot Backup MDF and LDF with TSM

    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...

  • RE: SuperSocket error

    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...

  • RE: Question of the Day for 25 Feb 2004

    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...

  • RE: Register same SQL Server more than once in EM

    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...

  • RE: Database Log File full

    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...

  • RE: Tough sql statement conversion

    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.

  • RE: How Frequent Do you Perform Restoration Test

    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...

  • RE: Disaster Recovery Site

    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.

  • RE: Database can't be reached by users

    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....

  • RE: DBAs versus SQL Server

    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...

  • RE: SQL occupied 90% usage and 99% outgoing traffic

    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...

  • RE: Stop/Start Instance In Cluster

    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,...

  • RE: 4 processor Dell machine for SQL server

    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...

  • RE: Backup time increased

    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...

Viewing 15 posts - 1 through 15 (of 32 total)