Forum Replies Created

Viewing 15 posts - 91 through 105 (of 218 total)

  • RE: Huge SQL Error Log - concern?

    I've always had a problem with the hard 80% threshold, especially when applied to backup drives.

    In your situation, I would cycle the SQL logs daily, keep a few days. ...

  • RE: RAID, SAN & Equality on DEVL & PROD environments

    Personally, I would still prefer to have more disks in production. Let's say you SAN team will give you 32 total disks. I'd rather have 24 in prod...

  • RE: Huge SQL Error Log - concern?

    Maninder S. (4/30/2010)


    Yes Large files are not a issue. but sometimes the policies across departments, lead us into a tight position.

    Thanks

    Then what's the question? SQL is defaulted to keep...

  • RE: Data display issue

    Write a cursor.

    Fetch each county into it.

    Create a variable and keep concat'ing the new county + a space

    When the cursor is done, print the variable that contains the string with...

  • RE: Backup when mssqlservice is stopped

    CirquedeSQLeil (4/30/2010)


    GregoryF (4/30/2010)


    I've also seen this behavior with Websense, and currently, we have a finincial compliance/disclosure 3rd party app that creates a new DB every day.

    I often wonder if the...

  • RE: RAID, SAN & Equality on DEVL & PROD environments

    rbowers 18291 (4/30/2010)


    Does anyone have information on storage set up for DW/BI? We are brand new to DW/BI on SQL Server 2008. We are a mainframe shop with source data...

  • RE: Backup when mssqlservice is stopped

    I've also seen this behavior with Websense, and currently, we have a finincial compliance/disclosure 3rd party app that creates a new DB every day.

    I often wonder if the people who...

  • RE: Backup of the T- logs

    The maintenance plan adds a unique time stamp to each T-Log dump in the file name

  • RE: Huge SQL Error Log - concern?

    Because log shipping fills up our logs quickly we have a job to roll the error log nightly, my usual policy is to keep 32 or 64 logs.

    Large logs are...

  • RE: Oracle RAC - SQL Server equivalent??

    The closest thing in SQL would be geo-clustering which offers multi-datacentre redendancy in a combined HA/DR solution. But it certainly does not offer load balancing. And geo-clustering is...

  • RE: sql remote server and agent status

    I have seen many servers with a "blank state". These are usually SQL2000 servers in a clustered environment. Microsoft has never gotten those to appear *** running/stopped in...

  • RE: SQL Server and VMWare

    Our's is on a VM server. I trust the NT group enough that they have built in sufficient redundancy (the VM server that VMWare sit's on is virtually clustered)....

  • RE: Backup and restore solution for 800TB of data

    Dugi (4/29/2010)


    GilaMonster (4/29/2010)


    Lowell (4/29/2010)


    Steve can you put out some numbers for perspective? SSC has a lot of users and traffic, compared to many of us small biz guys we usually...

  • RE: Backup and restore solution for 800TB of data

    Lowell (4/29/2010)


    Steve can you put out some numbers for perspective? SSC has a lot of users and traffic, compared to many of us small biz guys we usually deal with;...

  • RE: Monitoring - How to Alert The DBA when the Failure is at the Server level

    Our NT group monitor's the status of services. If a service enters the stopped status, we are alerted.

Viewing 15 posts - 91 through 105 (of 218 total)