Forum Replies Created

Viewing 15 posts - 5,101 through 5,115 (of 9,244 total)

  • RE: Restore TDE backup

    dan-572483 (9/4/2012)


    I'd like to restore a backup of a TDE-protected database to a different SQL 2008 R2 server instance. The target instance has no TDE DBs currently, but...

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

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

  • RE: Removing .NDF files from a SQL Mirror setup

    you're welcome 😎

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

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

  • RE: Standby-file location in log-shipping

    Usually its set to the secondary destination directory which you can get from the following

    exec sp_help_log_shipping_secondary_database 'yourdb'

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

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

  • RE: Installing SQL SERVER 2012 Developer Edition On Top of 2005 Editioon

    jrichards54 (9/4/2012)


    4 or 5 with SQL Server entries and three of them show the MSSQLSERVER.

    you probably have a default installation of SSRS and SSAS too as well as the...

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

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

  • RE: LSAlert job fails in job activity monitor in both DC & DR (Primary & secondary) servers in logshipping

    you're welcome

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

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

  • RE: Removing .NDF files from a SQL Mirror setup

    run a transaction log backup and re check

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

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

  • RE: Instance Level Failover in 2012 'Always On'

    Perry Whittle (8/29/2012)


    Your configuration is not clear from the above description, a secondary AlwaysOn instance is not allowed to run on the same node as a FCI included node when...

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

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

  • RE: LSAlert job fails in job activity monitor in both DC & DR (Primary & secondary) servers in logshipping

    please check the rssults of the following query when executed against your secondary database and post them back

    exec sp_help_log_shipping_secondary_database

    @secondary_database = 'secondary_database'

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

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

  • RE: LSAlert job fails in job activity monitor in both DC & DR (Primary & secondary) servers in logshipping

    naga.rohitkumar (9/3/2012)


    HI,

    As u mentioned i checkd the logs in sqlserver and event viewer

    even after all jobs are executed success fully i got this mesage

    the error message is...

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

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

  • RE: specify service account for Mirroring setup?

    If you're implementing mirroring on workgroup computers MS recommend you use certificates. For detailed information on how to implement mirroring in a workgroup see this link

    Alternatively you can use this...

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

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

  • RE: specify service account for Mirroring setup?

    why are you using local accounts for the services?

    Are your servers part of a windows domain or a workgroup?

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

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

  • RE: LSAlert job fails in job activity monitor in both DC & DR (Primary & secondary) servers in logshipping

    naga.rohitkumar (9/3/2012)


    HI,

    1. LSAlert job fails in job activity monitor in both DC & DR (Primary & secondary) servers in logshipping

    2. While manualy executing it is failing and msg in hisroty...

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

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

  • RE: Windows Cluster service account privilege on SQL 2005 cluster

    Jan.Sundbye (9/3/2012)


    Are you doing it manually? The installation program should take care of this.

    The SQL Server installer does not handle the OS permissions of the cluster service account!

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

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

  • RE: Windows Cluster service account privilege on SQL 2005 cluster

    tyang (8/31/2012)


    Can anyone provide the list of privileges (Local Security policy) which should be granted to Windows Cluster service account? Below is for SQL service account, should it be same...

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

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

  • RE: Installing SQL SERVER 2012 Developer Edition On Top of 2005 Editioon

    Jeffrey Williams 3188 (9/2/2012)


    If we know what 'it does not work' actually means we could probably help you. I would hate for you to go through the time and...

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

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

Viewing 15 posts - 5,101 through 5,115 (of 9,244 total)