Forum Replies Created

Viewing 15 posts - 8,626 through 8,640 (of 9,241 total)

  • RE: SQL Server - Domain controller

    kestak (12/18/2008)


    I do not even know if DC1 is integrated

    see below for how to check this

    kestak (12/18/2008)


    1 - How do I create the right way a secondary zone for...

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

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

  • RE: SCRIPTING JOBS IN SQL SERVER 2000

    Jobs are fairly portable its the DTS packages if you have any that give the real headaches

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

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

  • RE: Backup failed with VDI Error

    jayesh_kherwadi (12/17/2008)


    Hi Guys,

    The database is on SQL server 2000

    this is the SQL2005 forum you have posted into

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

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

  • RE: Backup failed with VDI Error

    what version is your SQL instance?

    VDI backwards compatibilty has a known issue with VLDB's and SQLVDI errors

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

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

  • RE: SQL Server DB 2008 wont re-attach after deleting log file

    what was the attach command you used?

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

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

  • RE: SQL Server - Domain controller

    kestak (12/16/2008)


    Greetings,

    Seconday DNs installed and running on DC1.

    you have ceated a primary zone and not a secondary?

    As both name servers are DC's set them to AD integrated too

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

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

  • RE: SQL Server - Domain controller

    you stated DC2 is a virtual server, just for clarification what hypervisor are you using to render this VM?

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

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

  • RE: Redgate Backup Of "System" databases

    :blush: doh log backup missed that one

    our maint jobs dont perform log backups on system db's either. Incidentally Jeff that error is from the SQL log by the looks of...

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

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

  • RE: Redgate Backup Of "System" databases

    Jeff

    can you post the actual error from the Redgate Backup log file on the server. It defaults to

    c:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\instancename

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

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

  • RE: SQL Server - Domain controller

    K. Brian Kelley (12/15/2008)


    True. On start-up it likely will, but after that it should keep its own time. We've had that problem.

    this is only true for MS VS2005, under VMware...

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

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

  • RE: sql profile on a given table

    set up column filters for the databasename (containing the object) and Textdata columns.

    assuming you were catching a table called "Blobdata" set the filter on textdata to

    Like %Blobdata%

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

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

  • RE: Downgrade

    install a new instance and migrate the objects then remove the old instance afterwards

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

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

  • RE: sql 2005 installation

    once you have updated usages and indexes\stats run the following against the database

    dbcc checkdb (mydatabase) with all_errormsgs, no_infomsgs, data_purity

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

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

  • RE: SQLVDI errors in Event Logs

    what is the version of your sql instance?

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

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

  • RE: SQL Server - Domain controller

    K. Brian Kelley (12/15/2008)


    This should be taken care of automatically thanks to the Windows Time service. The first DC (assuming it's holding the role of PDC emulator) should be set...

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

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

Viewing 15 posts - 8,626 through 8,640 (of 9,241 total)