your welcome!

No

you may also want to check my tutorial for installing SQL Server 2008 in a clustered configuration at this

link, it may help quite...

saimonkhan15 (5/21/2010)

---

In SQL 2000, you cannot give anyone else permission to truncate your table.

I have always thought this was a bit strange, since truncate is so much

faster. You can grant...

Alex Webber (5/21/2010)

---

Thank Perry. I have read that. But it still doesn't explain why 2 x backups are required, if anything that article insinuates that 1 backup should be enough!...

before removing any files check their contents. Can you post the results of the following queries?

USE yourdb

select name from sys.filegroups

USE yourdb

select a.name as 'Index name', b.name as 'Filegroup',

c.name as 'Table...

check this link for more info

the following info is relevant

A log backup is required to move the head of the log forward (full or bulk-logged recovery models only).

Note:

Log backups...

shew (5/20/2010)

---

Issue #1:

We are running Microsoft Failover Clustering on Windows Server 2008 R1 with SQL Server 2008 R1. We have one named instance installed and need to add a second...

In most cases Standard edition is suitable for what most people require. Unless you plan to have multi node clusters, require IA64 support, get heavily into partitioning, require compression and...

TRUNCATE requires ALTER permission on the table which you will also need for adding the constraint. You will probably also require ALTER on the schema too!

no its nothing like Office. Pick your self up a copy of the SQL Server 2008 training kit you can get it reasonably priced from Amazon, this is your best...

OK this slightly worries me. How can you expect a stable installation if you do...

Franco

transferring logins to SQL Server 2008 uses the same script that you have for 7\2000 to 2005

Hi Scott

i didnt...

Thank you, glad they are able to help you

on the failure notification it gives you the log location?