Forum Replies Created

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

  • RE: Return the records that equal the sum.

    Pretty cool.

  • 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...

  • 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...

  • 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...

  • 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. ...

  • 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...

  • 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.

    *...

  • 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...

  • 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...

  • 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...

  • 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,...

  • 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...

  • 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...

  • RE: Bulk Copy vs Simple recovery models

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

  • 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...

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