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...

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...

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...

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...

you can but its only really recommended in certain configurations

Mohammed Imran Ali (7/16/2013)

---

Thank you for the info on SPNs. I had checked the SPNs are registered under the SQL Server Service account names for both Instance name and the...

Is the table partitioned across multiple filegroups, is this file in its own filegroup?

Au contrair mon pere

All the dev and ore systems I have worked with are built to the same exacting specification.

As I said though if you partition the drives in accordance with best practices then compression is not available!

ariely.ronen (7/16/2013)

---

In fact what is written is not accurate.

Yes you can "Shrink SQL Database During Restore" using workaround 🙂 and with out "provide enough disk space (=size of the...

This link details rolling upgrades on sql server 2008.

Up to today or...

you're welcome

you're welcome

Add the domain user to instA and use impersonation.

Do you have your SPNs set up correctly otherwise windows authentication will still fail?