Forum Replies Created

Viewing 15 posts - 4,771 through 4,785 (of 9,244 total)

  • RE: script for lightspeed configuration

    Litespeed is a packaged installer which installs the binaries.

    You then need to launch the Litespeed configuration wizard, you could check with Quest if there is a way to script this...

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

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

  • RE: script for lightspeed configuration

    configure what exactly?

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

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

  • RE: Would a smaller number of VLFs in the log speed up the redo phase of recovery of a mirror snapshot?

    Marios Philippopoulos (10/16/2012)


    I will probably not do that, as it seems a bit too much voodoo to me... 🙂

    Whats voodoo about creating a table, inserting some records and truncating...

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

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

  • RE: Would a smaller number of VLFs in the log speed up the redo phase of recovery of a mirror snapshot?

    that is correct, did you perform the create, insert, truncate that Gail advised

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

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

  • RE: CLustering with Mirroring for Disaster Recovery

    can you supply a little more info on the virtual environment, are the VMs clustered directly or are you referring to host clusters?

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

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

  • RE: Shrinking Transaction Log File "the right way"

    i think the user was primarily confusing NOTRUNCATE and TRUNCATEONLY on DBCC SHRINKFILE with the BACKUP LOG scenario, i could of course be wrong but i'm sure this is the...

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

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

  • RE: Shrink of data file - DBCC SHRINKFILE - taking a long time and not completing - stuck at 99% completion

    Marios Philippopoulos (10/16/2012)


    I ended up shrinking the file, but had to wait a few hrs.

    😉

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

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

  • RE: Shrinking Transaction Log File "the right way"

    Your article mentions

    distas


    Here is important point in regards to DBCC SHRINKFILE not to be misinterpreted: DBCC SHRINKFILE (<Transaction_LogFile_LogicalName>, TRUNCATEONLY) does truncate a transaction log file, i.e. breaks the LSN -...

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

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

  • RE: Can i install sql server 2008 r2 on windows server 2008 r2 which has active directory users and computers

    vamsi056 (10/16/2012)


    i only installed Active Directory users and computers role ( to work with assigning user roles and permission from sql server to windows authentications), and i didnot installed DNS...

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

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

  • RE: uninstall default instance

    set the backup drive as a dependency on the sql server service resource and change the drives\paths on the sql server instance properties page

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

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

  • RE: Log Shipping principal taken offline, how to stop witness messages?

    remove traces of any redundant secondary databases on the secondary server using

    USE master;

    go

    exec sp_delete_log_shipping_secondary_database

    @secondary_database = 'secondary_database';

    Once you're sure any LS scenarios have been cleared remove the alert job...

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

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

  • RE: Can i install sql server 2008 r2 on windows server 2008 r2 which has active directory users and computers

    vamsi056 (10/15/2012)


    Hello friends,

    Iam a newbie to sql server dba tasks,

    I want to install sql server 2008 r2 enterprise edition on my laptop where os is windows server 2008 r2...

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

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

  • RE: Log shipping hybrid

    The log shipping meta data keeps a trcak of files copied and restored. Start messing with the plan itself and it will likely fail. If you want to run LS...

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

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

  • RE: Migrate 2005 system databases to 2012

    greg.huxley (10/15/2012)


    Perry, Steve

    Thank you for the information. Glad I checked before attempting! Are there any dependencies on the order in which I do the migrations i.e. do I...

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

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

  • RE: data folder permission

    chewychewy (10/12/2012)


    Hi,

    By default installation, SQLServer2005MSSQLuser$<INSTANCENAME>$MSSQLSERVER is having the below access to SQL Server Data folder.

    Full Control

    Modify

    Read and Execute

    List Folder Contents

    Read

    Write

    Auditor highlight that this is a security concern and want...

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

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

Viewing 15 posts - 4,771 through 4,785 (of 9,244 total)