apart from the obvious, check you have backups before starting, no. Install the service pack and...

dixon_dwayne (4/30/2012)

---

Question is: after initial full backup on prod box and all the transaction logs created on prod box, do I need to keep them or can they be...

check this link on the Microsoft website

derek.colley (5/1/2012)

---

Would have been nice to explore the topic of 1) virtualisation and 2) SANs and how the IOPS rates differ when using these different technologies. Any more articles...

Nice article, incidentally RAID 1+0 and 0+1 are not identical. As 0+1 is essentially 2 stripes the loss of 1 disk in each portion of the array is catastrophic. 1+0...

Windows Server 2008 Enterprise or above.

Sufficient shared storage solution.

Identical node hardware

That's because the command that will run is a log restore, i ran...

huh, how do you work that out, they both have the same end result, execute an SSIS package!!

wmlbill (4/26/2012)

---

SQL Server 2008 log file named changed

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

Hi all,

Some how the log file name on one of my databases changed from dbname_log.ldf to dbname_1.LDF Can anyone explain why this happened?...

use this

selectobject_name(i.object_id) as TableName

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

, i.index_id as IndexID

, i.type_desc as IndexType

, p.partition_number as PartitionNo

, p.rows as NumRows

, au.type_desc as InType

, au.total_pages as NumPages

, au.total_pages / 128 as...

+1

Rohit, you need to join allocation_units on the correct columns, let me find my script and post it back shortly

My preference would be to invoke the SMO objects directly within C# to backup the database

Fraggle-805517 (4/25/2012)

---

rudy - Doctor "X" (4/25/2012)

---

a few questions ...

How much RAM on the Windows side ?

How much RAM is allocated to SQL Server ?

Are you using any startup trace flags...

accounts are not synced thats a manual process, so what it is you are trying to...