Forum Replies Created

Viewing 15 posts - 4,006 through 4,020 (of 9,244 total)

  • RE: Install BIDS only

    the install media has install locations for x64, x86 and itanium.

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

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

  • RE: Splitting and shrink a Windows Volume without Cluster's downtime?

    sql-lover (7/25/2013)


    I want to shrink an existing LUN that holds tempdb and I want to do it on the fly, without taking the SQL failover instance down.

    Not going to possible,...

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

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

  • RE: SAN disk size expansion

    balasaukri (7/25/2013)


    Hi,

    We were trying to expand SAN disk size more than 2 TB as part our requirment. But it failed due to the limitation, NTFS can support maximum of 2...

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

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

  • RE: Log Shipping - Point In Time Recovery

    please provide full schedule details of any scheduled backups that occur so that a restore path may be suggested

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

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

  • RE: Adding New Node to exisiting SQL Server 2008 R2 Cluster

    Elliott Whitlow (7/25/2013)[hrI generally suggest you add ALL SQL instance to all nodes.

    I wouldn't advise this, in fact the SQL Server installation documentation directs you to install the clustered...

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

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

  • RE: litespeed restore

    Steveyam90 (7/25/2013)


    Otherwise you are stuck 🙂

    not necessarily, see my solution above.

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

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

  • RE: Splitting and shrink a Windows Volume without Cluster's downtime?

    shrinking is not as easy as extending a volume, from what i have read it seems that you want to convert to using mounted volumes is that correct?

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

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

  • RE: litespeed restore

    unless the backup was created as a self extracting archive its not going to be possible without

    • using the litepseed extract utility
    • installing litespeed to the target server

    Depending on the version of...

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

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

  • RE: LS

    kapil_kk (7/19/2013)


    Thanks Perry... I was unaware about this TUF file fact...

    Books Online is very clear on this, it must not be manually deleted other wise the database will need to...

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

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

  • RE: Moving storage (SAN hp -> eva) with SQL Mirroring

    saqlainkhan (7/16/2013)


    They want you to break mirroring while they move the storage?

    YES

    What are they moving, just the mirror instances storage or the principal too?

    THEY ARE MOVING JUST...

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

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

  • RE: I need cluster installation information

    New persopn (7/18/2013)


    Hi all

    Here we have to setup cluster environment for one of my client.

    Here we are having the 500gb hard disk and 8 instances.

    in that 4 applications are running.

    can...

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

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

  • RE: Index and Table Size

    I prefer this

    selectOBJECT_NAME(o.OBJECT_ID)AS TableName

    , ISNULL(i.name, 'HEAP')AS IndexName

    , i.index_idAS IndexID

    , i.[type]AS IndexType

    , i.is_disabledAS IsDisabled

    , FILEGROUP_NAME(i.data_space_id)AS FGName

    , p.partition_numberAS PartitionNo

    , p.[rows]AS [RowCnt]

    , p.data_compression_descAS CompressionType

    , au.type_descAS AllocType

    , au.total_pages / 128AS...

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

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

  • RE: LS

    HanShi (7/18/2013)


    SQL Server doesn't have a Transaction Undo File. I think you are working with Oracle. This forum is about Micorosoft SQL Server. Very few posters will have extensive experience...

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

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

  • RE: LS

    ramyours2003 (7/18/2013)


    .TUF -transaction undo file

    If you have your logshipped database in standby mode and you delete the .TUF file you'll need to re establish the log shipping plan.

    In short don't...

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

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

  • RE: PAE

    you can but its only really recommended in certain configurations

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

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

Viewing 15 posts - 4,006 through 4,020 (of 9,244 total)