Forum Replies Created

Viewing 14 posts - 1 through 14 (of 14 total)

  • RE: SQL 2000 + SAN

    Issue resolved.

    The problem was the MS SQL service was starting prior to the MS iSCSI service; thus the iSCSI target wasn't getting mapped until the SQL server was running.

    For infomation...

    May 12, 2009 at 1:51 pm

    #993257

  • RE: SQL 2000 + SAN

    David Benoit (5/12/2009)

    The other thing that shows up in a search for that error is that a virus scan may be actually locking the log file. Virus scan should be...

    May 12, 2009 at 12:12 pm

    #993182

  • RE: SQL 2000 + SAN

    David Benoit (5/12/2009)

    Are you validating that the permissions for the files / folders move over as well. I would verify that really well prior to attaching. Looks like a potential...

    May 12, 2009 at 12:10 pm

    #993181

  • RE: SQL 2000 + SAN

    Jason Shadonix (5/12/2009)

    But if you move it back from the S: drive to the C: drive after attaching/detatching, it works fine? Are you sure you are moving all of...

    May 12, 2009 at 11:53 am

    #993165

  • RE: Connect to a unique instance?

    Grant Fritchey (2/28/2008)

    Yeah, but did you log in from a different machine to the server? The reason is, you need to confirm that it's allowing external connections.

    ODBC works fine with...

    February 28, 2008 at 7:19 am

    #783150

  • RE: Connect to a unique instance?

    Grant Fritchey (2/28/2008)

    Verify that you've got the names correct. Can you connect using management studio from a different machine?

    I logged into the server itself, and noted the name [liuspc01\spc01] and...

    February 28, 2008 at 7:06 am

    #783140

  • RE: Connect to a unique instance?

    Phillip Cox (2/28/2008)

    Hi,

    You will need to use servername\instance name to connect (e.g. MyServer\MyInstance).

    That's exactly what I entered and it returns a failed to connect error??

    February 28, 2008 at 6:13 am

    #783119

  • RE: Differential Restore?

    Lucky,

    Thank you very much! That resolved the issue!

    Kerry

    February 6, 2008 at 7:40 am

    #775587

  • RE: Automated backup

    Steve Jones - Editor (1/30/2008)

    Be sure that you are running transaction log backups as well if you are in full recovery model. you can add this to the maintenance plan.

    Do...

    January 31, 2008 at 12:58 pm

    #773913

  • RE: Automated backup

    Ok, update.

    I performed the following:

    1. Formatted the drive, installed OS, installed SQL 2005

    2. Restored my specific DB

    - NOTE: Did NOT restore the MASTER DB

    3....

    January 30, 2008 at 9:35 am

    #773389

  • RE: Automated backup

    Steve Jones - Editor (1/30/2008)

    Be sure that you are running transaction log backups as well if you are in full recovery model. you can add this to the maintenance plan.

    Do...

    January 30, 2008 at 8:56 am

    #773353

  • RE: Automated backup

    Thanks for the help! The Maintenance Plan (Wizard) worked great. Scheduled backups are running fine.

    Kerry

    January 30, 2008 at 6:47 am

    #773247

  • RE: Simple as restoring?

    Ellis RemoteDBA (1/29/2008)

    will you need to rebuild/restore the system databases too?

    To restore a user database you don't need to create a database first , you can restore straight from...

    January 30, 2008 at 6:31 am

    #773233

  • RE: Automated backup

    jiqubal (1/28/2008)

    you can create a job to make a schedual backup of yourdatabase, if you r running a sql server 2005

    Can you elaborate?

    I already know how to manually run a...

    January 28, 2008 at 3:56 pm

    #772683

Viewing 14 posts - 1 through 14 (of 14 total)