Forum Replies Created

Viewing 15 posts - 6,181 through 6,195 (of 9,244 total)

  • RE: Restricting access to SQL Server instances based on source IP or hostname?

    Chris Metzger (12/21/2011)


    Is anyone doing this? I am attempting to restrict access per instance (multiple instances per SQL Server) so that only a specific source IP or hostname can...

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

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

  • RE: Using and Creating Mount Points in SQL Server

    okbangas (12/21/2011)


    A little piece of missing information: You describe some of the differences between MBR and GPT, but in my opinion you lack the most important one: MBR can only...

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

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

  • RE: Unable to remove t-log file

    khandelwal_arun (12/20/2011)


    The issue has been resloved thanks for your prompt help... 🙂

    I really appriciate your prompt and helpful response....

    Thanks,

    Care to share the resolution, it may help others in future

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

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

  • RE: Log shipping SQL 2008 from SQL 2008?

    once you complete the restore and upgrade from 2000 to 2008 you must run the following against the database

    DBCC UPDATEUSAGE

    Followed by

    DBCC CHECKDB WITH DATA_PURITY

    Then go rebuild all your indexes...

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

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

  • RE: Mount-point related error during SQL installation on cluster node

    as already mentioned, see my article at this link[/url] for more info on setting up and using mount points for SQL Server

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

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

  • RE: Unable to remove t-log file

    khandelwal_arun (12/20/2011)


    Hello,

    Can you please help me out how I remove log_reuse_wait_desc = Replication to Active_Transcation.

    Thanks in advanace for help me out ...

    Regards,

    Are you taking regular backups of the publication\distribution databases?

    Is...

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

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

  • RE: While I am creating the Cluster of sql server 2008 R2 I am getting error:

    Ignacio A. Salom Rangel (12/20/2011)


    Maybe you could blog about it!

    See my link above 😉

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

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

  • RE: SQL Server Instance is not coming UP after installation of SP2 in Failover Cluster environment.

    check the event log for any messages.

    Take the group offline and then bring the resources up 1 at a time in the following sequence

    1/ IP address

    2/ Network name

    3/...

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

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

  • RE: How can i do Failover in replication

    a replicated database cannot really be considered a true 100% copy of your original database, what if a connection needs to use an object you have not replicated to the...

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

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

  • RE: While I am creating the Cluster of sql server 2008 R2 I am getting error:

    JohnnyDBA (12/16/2011)


    Microsoft believes the root cause is an issue with the mount point configuration.

    I'd be inclined to agree.

    Where are your disks presented from for the mounted volumes are they...

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

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

  • RE: Changing authentication mode in a cluster

    yes, it is a change to the registry. The cluster service should replicate the key change to all nodes required

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

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

  • RE: TSQL for getting detailed drive info on a Cluster

    for mounted volumes use the following

    wmic volume get name, "Free Space", capacity

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

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

  • RE: log shipping and transaction log

    Transaction log backups are an important part of log shipping. Digest the info in books online and post back if you're still stuck.

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

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

  • RE: Another Mirror vs Log shipping question

    chopperGuy (12/16/2011)


    We have an environment which has database close to 500 GB. The log backups generate about 80-90 GB worth of logs.

    Problem we are facing is that copy process...

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

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

  • RE: Master Key Error

    I would of thought you would see a message indicating that the master key already exists, firstly check the results of

    select * from sys.symmetric_keys

    If you have more than 1...

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

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

Viewing 15 posts - 6,181 through 6,195 (of 9,244 total)