Forum Replies Created

Viewing 15 posts - 5,626 through 5,640 (of 9,253 total)

  • RE: Quorum ?

    dba92054 (4/25/2012)


    Thanks! How do I fail the Quorum drive over to the other node without restarting the entire server? Or is the only time the Quorum drive on...

  • RE: Recover sa Password

    paul.knibbs (4/25/2012)


    because you're guaranteed to only have one connection active when you use that. (And he's using Express Edition, so no problem with the Agent... :-)).

    That's just it you're not!...

  • RE: WAN failover

    gregtm (4/25/2012)


    I've been using log shipping for years and it has worked great...Especially the fact you can delay the restore to protect against corruption or user deletion....etc. However, the Exec's...

  • RE: Quorum ?

    dba92054 (4/24/2012)


    The Quorum isn't in a group like a 2003 cluster is though. It shows in the Storage section of the Failover Cluster Manager only. Is this normal?...

  • RE: Want to confirm setup to be able to backup to UNC

    jasona.work (4/24/2012)


    1. Create a local user account on the SQL Server, and a matching account on the share server

    2. Grant the account access to the share and the...

  • RE: query from dm_db_index_physical_stats

    sqlfriends (4/24/2012)


    Thank you very much, that helps a lot.

    If all you're looking for is index sizes and row counts, etc try this

    selectobject_name(i.object_id) as TableName

    , ISNULL(i.name, 'HEAP') as IndexName

    , i.index_id as...

  • RE: SQLVDI and then Terminate Unexpectedly

    Fraggle-805517 (4/24/2012)


    We have Litespeed set to "Verbose, cleanup on success" so I have stuff that Litespeed is looking into.

    The event logs don't show any restart errors.

    Fraggle.

    a;; of the...

  • RE: RAID configuration for SQL Server 2008 Database with 8 hard disks

    Orion Pax (4/24/2012)


    So I too proposed a three RAID setup of:

    Drive RAID Cnt ...

  • RE: SQLVDI and then Terminate Unexpectedly

    Have you enabled Litespeed logging this will provide more info?

    Try checking the windows application and system logs for any potential restart errors

  • RE: Can you restore a 2008 DB to 2005?

    rummings (3/13/2012)


    I tried to use an SSIS package, but it complained about the versions. I think tried Export/Import.... still received version errors. I then tried to generate a create...

  • RE: Created availability group, but cannot connect to listener

    winston Smith (4/22/2012)


    I have created an availibity group with 2 databases, across 3 servers.

    ServerA is the primary server

    ServerB is synchronous failover

    ServerC is synchronous readonly copy of the data.

    I created a...

  • RE: Problem Uploading large files

    Check the maxfileupload size in IIS, it defaults to 5MB you may want to change this

  • RE: Dynamically configure/deploy database using database projects and/or DTA

    SMO has various methods you can exploit to do a whole range of database interaction tasks through C# and VB.net

  • RE: DBCC

    In general the DBCC commands are database engine direct functions, they have thousands of lines of code behind them.

    What is it you are expecting or would like to see?

  • RE: Creating a 2 Node SQL Server 2008 Virtual Cluster Part 3

    APA0876 (4/23/2012)


    Perry,

    I finally found the article Part 3, this is wonderful, I just have question can I have multiple default sql instances on a SQL cluster? Or just one default...

Viewing 15 posts - 5,626 through 5,640 (of 9,253 total)