Forum Replies Created

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

  • RE: Return the records that equal the sum.

    Pretty cool.


    "Keep Your Stick On the Ice" ..Red Green

  • RE: Backup detected log corruption in database

    I agree with Paul's assessment about it being the I/O subsystem. One thing I would not do in this situation is run a full backup. Chances are it...


    "Keep Your Stick On the Ice" ..Red Green

  • RE: altering subscription?

    It has been a long time since I have worked with replication and am in a similar situation.   I have a script that is from a third party vendor that...


    "Keep Your Stick On the Ice" ..Red Green

  • RE: Permissions for DBCC commands

    Thanks everyone.   I found a solution.  sp_spaceused isn't accurate enough unless you update the usage....which is resource intensive.

    I did a little research and found that

    select fileproperty(f.name,''SpaceUsed'')*8/1024.00

    from sysfiles f

     

    gives me the...


    "Keep Your Stick On the Ice" ..Red Green

  • RE: Snapshots

    Okay...this has been a while ago.  I did manage to restore the database and roll the transaction logs.  There are some command line utilities that you will need to utilize. ...


    "Keep Your Stick On the Ice" ..Red Green

  • RE: Cluster administrator

    Fight the good fight!

    I am sure there is some documentation out there from MS that basically tells you to start and stop SQL Server through the Cluster Administrator and to...


    "Keep Your Stick On the Ice" ..Red Green

  • RE: new dba seeks on-the-job advice

    Naomi,

    Good luck. Getting your recovery capability together is a good start. I don't want to overwhelm you with information right now, but do wish to share some thoughts.

    *...


    "Keep Your Stick On the Ice" ..Red Green

  • RE: I''''m getting error when attaching database

    If he is trying to connect to a Network drive (UNC) then the trace flag is going to have to be set and the RDBMS restarted. SQL Server (for...


    "Keep Your Stick On the Ice" ..Red Green

  • RE: Merge Replication - Unable to reinstate article

    Sometimes the gui isn't always the most helpful. Try creating the scripts for merge replication by right clicking on the replication folder through enterprise manager.

    You may have to drop...


    "Keep Your Stick On the Ice" ..Red Green

  • RE: A little lesson on life

    This is a great site and for those of you that are new to here may I suggest becoming part of the 'community'. You'll get to enjoy the likes...


    "Keep Your Stick On the Ice" ..Red Green

  • RE: A little lesson on life

    Thanks for the posts. There is some excitement with the unknown, and this has inspired me to write a very constructive article on job searching.

    Edward, I have to ask,...


    "Keep Your Stick On the Ice" ..Red Green

  • RE: Dropping computed columns

    My reply... 🙂

     

    Why do I want to drop the formula (not the column)?  The formula does not allow the column to be updated from the application since the formula is...


    "Keep Your Stick On the Ice" ..Red Green

  • RE: Truncating Transaction Logs

    Not what I expected.  Very interesting to say the least.   I wonder if throwing a CHECKPOINT at the database before the truncate would have effected the restore..Something doesn't seem right...


    "Keep Your Stick On the Ice" ..Red Green

  • RE: Bulk Copy vs Simple recovery models

    .........but, does simple log bulk copy operations?


    "Keep Your Stick On the Ice" ..Red Green

  • RE: High CPU Usage

    Dexter...

    Could you keep us posted as to your findings and the type of SAN your using?   I am guessing...and bear in mind this is just a guess..that there aren't issues...


    "Keep Your Stick On the Ice" ..Red Green

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