Forum Replies Created

Viewing 15 posts - 241 through 255 (of 442 total)

  • RE: Question regarding Log issues with Mirroring database.

    GilaMonster (3/15/2013)

    SQLCrazyCertified (3/15/2013)

    I thought it should truncate the inactive logs after logbackup\shrink are done.

    Just like any other database in full recovery, the logs are truncated (marked as reusable) when a...

    Regards,
    SQLisAwe5oMe.

    March 15, 2013 at 3:18 pm

    #1597718

  • RE: Question regarding Log issues with Mirroring database.

    Lynn Pettis (3/15/2013)

    I personally never tried shrinking the log of a mirrored database. If you can, perhaps you could set this up on a test server and see what...

    Regards,
    SQLisAwe5oMe.

    March 15, 2013 at 2:53 pm

    #1597697

  • RE: Is this is the Best Practice to select E: for the SQL Server root directory?

    Sqlism (3/11/2013)

    Thanks for the reply

    I mean to say any other driver other than C drive. I specified E drive as example. sorry for the confusion. So can someone conclude that...

    Regards,
    SQLisAwe5oMe.

    March 11, 2013 at 7:27 pm

    #1595797

  • RE: Is this is the Best Practice to select E: for the SQL Server root directory?

    SQLCrazyCertified (3/11/2013)

    Sqlism (3/11/2013)

    Thanks for the reply, so u suggest to seperate sql

    Binaries from

    OS binaries ?

    My question is , is this is the best practice to change root directory from default...

    Regards,
    SQLisAwe5oMe.

    March 11, 2013 at 1:57 pm

    #1595725

  • RE: Is this is the Best Practice to select E: for the SQL Server root directory?

    Sqlism (3/11/2013)

    Thanks for the reply, so u suggest to seperate sql

    Binaries from

    OS binaries ?

    My question is , is this is the best practice to change root directory from default location...

    Regards,
    SQLisAwe5oMe.

    March 11, 2013 at 1:48 pm

    #1595723

  • RE: Is this is the Best Practice to select E: for the SQL Server root directory?

    Normally, from my experience, SQL binaries goes to D: drive and separate data, log and temdb to different drives based on your environment standards.

    SueTons.

    Regards,
    SQLisAwe5oMe.

    March 11, 2013 at 1:32 pm

    #1595717

  • RE: SQL Max server memory settings

    opc.three (3/1/2013)

    Nah, see my last post.

    Yea got it. I replied before I read your post.

    Thanks again.

    SueTons.

    Regards,
    SQLisAwe5oMe.

    March 1, 2013 at 6:19 pm

    #1592628

  • RE: SQL Max server memory settings

    opc.three (3/1/2013)

    No problem. One tweak for clarity. My query should have qualified the table with the new name of master, not master again:

    SELECT *

    FROM new_name_of_master.sys.configurations

    WHERE ...

    Regards,
    SQLisAwe5oMe.

    March 1, 2013 at 5:51 pm

    #1592625

  • RE: SQL Max server memory settings

    Thank you.

    SueTons.

    Regards,
    SQLisAwe5oMe.

    March 1, 2013 at 3:23 pm

    #1592606

  • RE: Applying checkpoint

    GilaMonster (2/28/2013)

    The login needs to be sysadmin or to have db_owner or backup admin fixed server roles on the database where the checkpoint is run. If you are running checkpoint...

    Regards,
    SQLisAwe5oMe.

    February 28, 2013 at 1:30 pm

    #1592178

  • RE: Applying checkpoint

    GilaMonster (2/28/2013)

    From Books Online:

    Permissions

    CHECKPOINT permissions default to members of the sysadmin fixed server role and the db_owner and db_backupoperator fixed database roles, and are not transferable.

    Thanks Gail, but this particular...

    Regards,
    SQLisAwe5oMe.

    February 28, 2013 at 12:22 pm

    #1592157

  • RE: Transaction Logs Full

    Ausman,

    Just changing the recovery model to simple does not truncate the log....I think it has to wait for the next checkpoint to happen.

    Also, I have noticed that if you haven't...

    Regards,
    SQLisAwe5oMe.

    February 21, 2013 at 1:05 pm

    #1590109

  • RE: Shrink Data file with truncateonly

    anthony.green (2/19/2013)

    SQLCrazyCertified (2/19/2013)

    mwagh (2/19/2013)

    Thanks!! works in my case as i have a lot initially allocated space which was never touched.

    Hi, sorry, I was not aware of this, anyway,...

    Regards,
    SQLisAwe5oMe.

    February 19, 2013 at 5:17 am

    #1589148

  • RE: Shrink Data file with truncateonly

    mwagh (2/19/2013)

    Thanks!! works in my case as i have a lot initially allocated space which was never touched.

    Hi, sorry, I was not aware of this, anyway, with truncate...

    Regards,
    SQLisAwe5oMe.

    February 19, 2013 at 5:13 am

    #1589142

  • RE: Shrink Data file with truncateonly

    mwagh (2/19/2013)

    Hi,

    I wanted to shrink a data file with the truncate only clause.Will i require to rebuild my indexes?

    Shrinking data file is not recommended as it will create fragmentation and...

    Regards,
    SQLisAwe5oMe.

    February 19, 2013 at 2:36 am

    #1589078

Viewing 15 posts - 241 through 255 (of 442 total)