Forum Replies Created

Viewing 15 posts - 7,951 through 7,965 (of 9,244 total)

  • RE: Restore (database onwer)

    honestly i cannot any of this would generally be an issue. I do not enable CDOC, as the KB says you must be fully aware of the security implications. If...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL Server and Windows Cluster

    Hi

    welcome to Windows clustering. Which version of Windows clustering are you planning to use 2003 or 2008. Just for clarification what version of SQL Server do you plan to use,...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Error Installing SQL 2008 x64 Setup Support Files

    Hi

    try installing the following file first then re run setup

    'E:\Software_Installations\SQLServer_2008\x64\setup\sqlsupport.msi

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Give sysadmin privilege to local administrators group during installation

    you have the option to provision accounts during the install, why not use that?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Differential Backups

    use the following to ascertain backup sets that have been initaited against the database. Check the output to see if there are any unexpected\manual backups outside of the regime you...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Increasing SQL Server memory

    Edogg (5/14/2010)


    Also AWE does not need to be enabled on 64 bit systems.

    No, but lock pages in memory probably should be!

    If you start seeing the following in the SQL Server...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Moving databases

    george sibbald (5/14/2010)


    Mirroring would be too risky with the poor latency you are likely to have.

    i couldnt agree more, that would be my concern!

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Increasing SQL Server memory

    BharatBhushan (5/13/2010)


    I have sql server 2005 sp3 on windows server 2003 sp2. I am curious if I have free memory available on OS level and I want to increase SQL...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Moving databases

    Rome1981 (5/13/2010)


    Mirroring.

    if you have unreliable band width then this is not the best solution

    Is it that much of an issue if it takes an hour and a half. How much...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Finding Column,Table in Database for Data

    something along the lines of the following should work

    use yourdb

    select t.name as TableName, c.name as ColumnName from sys.tables t

    inner join sys.columns c on t.object_id = c.object_id

    where c.name = 'Yourcolumnname'

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Differential Backups

    What version\service pack are you using?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: backups to a SAN

    If the SAN goes down chances are the whole business is down too, while it's a good scenario to plan for it's more realistic that a disk in your array...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Backup whole instance, restore to a new server, with all the logins and permissions intact

    Grant Fritchey (5/12/2010)


    You can backup & restore msdb between servers. Assuming the drives are the same, your Agent jobs should be ok. If the drives & whatnot are different, you'll...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Maintenance Plan not deleting physical backup file

    Have any other hotfixes been applied at all?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: How to move the system datafiles (tempdb, master. msdb,...) to a diff drive(d$ -> E$)

    Sourav-657741 (5/12/2010)


    Thank Perry Whittle. However, will the above sugestion work file for SQL Server 2000?

    no, i would try posting in the sql server 2000 forum in the future 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 15 posts - 7,951 through 7,965 (of 9,244 total)