Forum Replies Created

Viewing 15 posts - 76 through 90 (of 219 total)

  • RE: Log size limit?

    chrisph (5/5/2010)

    Yes the log file is set to autogrow by 10% (which was 100MB), I have set this to 50MB now.

    The database is in FULL recovery mode.

    There are no log...

    /* ----------------------------- */
    Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

    May 5, 2010 at 10:39 am

    #1162627

  • RE: lost passwords--any hope?

    If the sql server is running under a domain service account, then you could very gingerly go into AD and change the password, the RDP into the SQL Server using...

    /* ----------------------------- */
    Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

    May 5, 2010 at 8:14 am

    #1162471

  • RE: Deleting TempDb log files

    Bhuvnesh (5/5/2010)

    In our environment , we have 3 log files for TempDB. my database director asked me to removed 2 tempdb file. he sail that we are fine with one...

    /* ----------------------------- */
    Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

    May 5, 2010 at 7:21 am

    #1162415

  • RE: SQL Server Port Number Script

    The multi-server query is a great addition to SSMS, I remember just a couple of years ago when you would have had to RDP into 70 servers to get this...

    /* ----------------------------- */
    Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

    May 4, 2010 at 6:29 pm

    #1162192

  • RE: SQL Server Port Number Script

    It will iterate through server's if you are using a multi-server query that is available in SSMS2008, otherwise it will show just the server that you are querying against.

    /* ----------------------------- */
    Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

    May 4, 2010 at 6:07 pm

    #1162184

  • RE: Cannot connect to (local), localhost, . or 127.0.0.1 in SQL 2008 cluster

    verygrumpydba (5/4/2010)

    I've got a SQL 2008 2-node active/passive cluster (on Windows Server 2008 R2) that when I am remoted into the server I can connect to the default SQL instance...

    /* ----------------------------- */
    Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

    May 4, 2010 at 1:36 pm

    #1162062

  • RE: SQL server memory usage

    Was/Is "Max Memory" configured?

    You have to be specific when asking questions, no bod know why two servers use different memory amounts when you have told us nothing of what version,...

    /* ----------------------------- */
    Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

    May 4, 2010 at 1:33 pm

    #1162061

  • RE: Microsoft SQL Server Management Studio Error

    RonKin (5/4/2010)

    I currently have a 2 node SQL Server 2005 Test Cluster. I am trying to add a database to the test cluster. I have copied the dotCMS-dev.mdf...

    /* ----------------------------- */
    Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

    May 4, 2010 at 12:06 pm

    #1162016

  • RE: What is the "ideal" hardware configuration for SQL Server 2008

    bdavey (5/3/2010)

    Ok Lynn, how about this:

    If you had $200K to spend on hardware, including storage, for an SQL server setup what would it be?

    It depends on what it's used for...

    /* ----------------------------- */
    Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

    May 3, 2010 at 10:53 am

    #1161393

  • RE: Preventing NT AUTHORITY\SYSTEM to take backups

    Are you running SQL Server using a domain account or a local account?

    More than likely you have it running as a local account.

    NT Authority\System just does not take backups, you...

    /* ----------------------------- */
    Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

    May 3, 2010 at 5:54 am

    #1161199

  • RE: Configuring a dedicated port to SQL Server instances.

    Intuitevly that's all wrong, if your using dymanic ports you need it, not for static.

    Here's is MSFT's documentation for the browser service for 2008, it makes no mention of it...

    /* ----------------------------- */
    Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

    April 30, 2010 at 12:00 pm

    #1160663

  • RE: Event ID 7034

    jason.nodarse (4/30/2010)

    I looked at the System amd Application log files and this is where I found the 7034 error. I have not looked at the cluster.log as of yet.

    Could...

    /* ----------------------------- */
    Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

    April 30, 2010 at 11:50 am

    #1160653

  • RE: Event ID 7034

    This is a very good tool for looking at the cluster log

    http://www.microsoft.com/downloads/details.aspx?familyid=B898F587-88C3-4602-84DE-B9BC63F02825&displaylang=en

    /* ----------------------------- */
    Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

    April 30, 2010 at 11:45 am

    #1160649

  • RE: Event ID 7034

    jason.nodarse (4/30/2010)

    The SQL Server 2005 (MSSQLSERVER) Service Terminated unexpectedly.

    I am running SQL Server 2005 SP2 in a Microsoft cluster.

    Can anyone please shed some light on this for me?

    Not without more...

    /* ----------------------------- */
    Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

    April 30, 2010 at 11:43 am

    #1160646

  • RE: Configuring a dedicated port to SQL Server instances.

    Mani-584606 (4/30/2010)

    I've done this, and we've set static ports in the firewall. If you don't do this, then you open a big range on the firewall, which upsets security people....

    /* ----------------------------- */
    Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

    April 30, 2010 at 11:39 am

    #1160645

Viewing 15 posts - 76 through 90 (of 219 total)