with SSMS, you can script the restore statement it will use. (use the script button after you've filled out everything you need.)

Can you script it to a new query window...

- what kind of error are you getting ??

- can you post the script ?

We always take backups to local disk, the xcopy the bak files to a UNC-resource (safezone).

If you've run out of disk slots to add more disks, you may even consider...

the scripts just checks if these startup parameters exist for your sqlserver instance,

and adds them if needed.

This way, the deadlock notifications in the sqlserver errorlog are always logged, even if...

am (11/6/2008)

---

can you please...

GilaMonster (11/6/2008)

---

Can you ask the users what exactly they mean by 'locking'?

3605 isn't required for deadlock graphs. Personally I find 1204 to be unnecessary if 1222...

Is this a migrated database from sql2000 ?

if so:

- rebuild all indexes

- sp_updatestatistics

- dbcc updateusage(0) with count_rows

and if you can ... dblevel to 90 !

add the following startup parameters to your sql instance.

This way you'll see in the sqlserver errorlog what statements are suffering

the conflict(s).

--dynamic activaton

dbcc traceon(1204, 1222, 3605, -1)

declare @MaxSQLArg varchar(50)

declare @NewSQLArg...

can you run sp_updatestistics and dbcc updateusage(0) with count_rows ?

This should get you fresh stats ...

starting a SQLTrace will also help to determine the source of your deletes.

bring on the caffeine.

We have a volume licensed Dev Edtn.

Also keep in mind, if you don't supply a key, it will install a Ent edtn for 140 days.

You can off course create a trigger for delete on that table to perform a rollback for delete statements and raise en error stating all connection info.

did you check out backup compression softwares ?

They typically reduce the size to +/- 20%

there is off course the undocumented :crazy: [sp_MSforeachtable].

Keep in mind the order of execution if you have DRI.

(or repeat more than once)

If you want to avoid log overhead, try to...

use an insert/update trigger to check the condition and rollback if invalid.