Start here :

- Gails very nice summary: http://www.sqlservercentral.com/articles/64582/

- Books online topic "Implementing Restore Scenarios for SQL Server Databases"

You really need :

- Full backup (= snapshot of your database)

- log backup...

I would...

the urls both state on 32-bit win2003 std edtn : 4Gb is the max.

it depends:

- 32 bit 4GB max

- 64 bit 32GB max

http://technet.microsoft.com/en-us/library/cc758523%28WS.10%29.aspx

or

http://msdn.microsoft.com/en-us/library/aa366778%28VS.85%29.aspx#physical_memory_limits_windows_server_2003

Start with properly design of your own tables !

DON'T use varchar(max) for everything ! Only use it if needed (>8000 bytes to be stored in a single column)

Is this a single shot operation ?

Use the import / export data wizard in enterprise manager/instance/database/tables rightclick on a table object.

Check out DTS in books online

Steve already couvered the DRP part.

Just to add a little bit to Keep in mind:

- SQL2005 has many features "off by default" on a fresh install. If you perform...

Nic-1052152 (9/28/2009)

---

Hi all

I have two front ends for my database; an old one in access and a newer one in vb.net.

I have a script which will script many new clients...

Be sure to double check your sql2000 settings (config + security) before starting the upgrade.

In case of DRP, you may have to start from sql2000 again, so if you don't...

Unless you capture plan cache, you have no means of history !

And if thing start going bad, it may go steep downhill !

Bad design (view on view, ..) probably ......

Works like a charm.

Thanks for the tip Starunit. :smooooth:

Keep in mind, that with every hotfix / servicepack, this needs to be rechecked (composition of the xml as well as the...

Nice feedback Jack.

Keep in mind 24h don't make a week, month , year 🙂

Did you trace on the same weekday as when you detected the growth ?

Well, it is a...

Thank you for the refs, Dale.

I'll try them next week.

Johan

did you try this in query analyser ?

alter table yourtable

add SurrogateId int identity(1,1) not null primary key

This should add the wanted column as well as the PK constraint (clustered by...

- SQL2005 introduced the OUTPUT clause. You could use that to do what you intend to.

- Why don't your perform a direct update of T2 ?

DECLARE @opt table (thecol int)

UPDATE...