Forum Replies Created

Viewing 15 posts - 211 through 225 (of 474 total)

  • RE: Maximum instances supported by SQL Server 2008

    Didn't we have a question about how many instances you can install a few months ago? Or was the one I'm thinking of for 2005?

  • RE: SQL 2000 + SAN

    Have you run a DBCC on the database prior to detatching just to make sure all is OK?

    Also, can you create a dummy database on that S: drive to make...

  • RE: SQL 2000 + SAN

    kerry.corcoran (5/12/2009)


    Windows Server 2000

    MS iSCSI Initiator 2.08

    Equallogic SAN

    Currently my DB's reside on the local C: drive of the server. I want to move the DB's to another drive with...

  • RE: Create Database

    Lynn Pettis (5/12/2009)


    I think all the complaints are out of line. I answered the question correctly, and I didn't even try to run the code.

    There should be a new...

  • RE: Create Database

    I thought it was a good question.

    Those of you saying the syntax is not correct, where are you getting a syntax error? As long as those paths...

  • RE: General Network Errors

    Roy Ernest (5/8/2009)


    [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.

    Unfortunately this is a generic error that is thrown for quite some scenarios.

    Don't you love that error? Have...

  • RE: Weird datetime conversions

    Formatting issues aside, I thought this was a good brain teaser.

  • RE: The Best High Availability

    We used DoubleTake a few years ago, but found it to be buggy. Since (at least the version we were using) is basically glorified file replication on the database...

  • RE: The Best High Availability

    Ah, good point. In our case we care more about not losing data than we do a couple of min. of downtime, so mirroring works out swell.

  • RE: The Best High Availability

    thirumalai (4/29/2009)


    SQL 2005 Data mirroring (Synchronous) with Log shipping sounds to be a good HA solution, when compared to the clustering. Data mirroring is for HA and Log shipping is...

  • RE: SQL Server 2008 Mirroring Testing

    No. You won't be able to restore your 2008 principal backup on your 2005 mirror server.

  • RE: Database Stuck Recovering

    My problem went away when I bounces the SQLSERVER service. But sounds like you already have. Might give it awhile. If it is a big DB or...

  • RE: @@CPU_BUSY

    ChacMoll (4/17/2009)


    I disagree with the answer, that the return value exceeds the limit of an integer, a variable of type integer is not able to save millions

    The answer is correct.

    Per...

  • RE: Server 2008 Connection issues

    I was getting a login failed error.

    Actually I just figured it out.

    Apparently Server 2008 is like Vista and doesn't put admins in the sysadmin role automatically,...

  • RE: TSQL

    serinor.e090266 (3/27/2009)


    I dont know if there is a problem, but i have tested the sentence in a SQL Server 2005

    More information:

    1)

    Output for SELECT @@VERSION

    Microsoft SQL Server 2000 - 8.00.2039...

Viewing 15 posts - 211 through 225 (of 474 total)