The TRUNCATEONLY parameter prevented the shrink from retrieving any space. This option means 'just chop any unused space off the end of the file without moving any data about'. If...

As silverfox said, still worth splitting the job up into tables, lynn pettis posted an article on this very recently, his script would be a starter for 10. Kick off...

The process of attaching or restoring the SQL2000 database to the 2008 instance would upgrade it to a SQL2008 database.

run the upgrade advisor against the SQL2000 instance to see if...

As for option 2) reporting services I highly recommend you follow KB article 842425.

Answering question 1) is a big subject with many options. how much data are you moving? how...

ah, bosses, god bless them. show him\her your working installation, do a test failover if you have to. see what a google search turns up.

I don't recall a definitive statement...

there are no problems with this setup. the fact you have configured it and it works proves it.

Steve Jones - Editor (9/15/2009)

---

Also note that if you have clients using the SNAC client or a recent ADO.NET driver, you can add both servers in the connection string. ...

A hardware level corruption is as likely to hit the resource db as any other, and someone deleting it is not out of the question. You could copy it from...

Eduard, it protects you against loss of the resource db only. thats one scenario, and you only need one.

agreed, it only changes when upgrades are applied, so thats the only...

best way to initialise the database on the failover server will be backup\restore. You will need to do this anyway to prepare the database for either log shipping or mirroring....

It is certainly a good idea to do some sort of replication so your target database is almost up to date as this will minimise the outage when you failover....

DKG, that does not work, info on SP levels are kept in other places e.g. the registry.

If you need to regress to a previous level in SQL2005 the only option...

Eduard (9/15/2009)

---

george sibbald (9/12/2009)

---

nice to have a copy of it though in case something happens to the original. Also saves having to re-apply service packs if you have to run...

Its a good bet they are VM's as well I suppose.

Its not really the point of the editorial but I also was wondering what the DR strategy was for this data centre.

I presume there is a duplicate somewhere? (twice the...