Default trace doesn't capture Stored Proc create & drop ... according to my test just now. The default trace never seems to have what I need, so I set up...

Something like this will give you a history of backups. You can specify the database & time period if you want.

SELECT sysdb.name, bkup.description, bkup.backup_finish_date,

case

when type='D' then...

Sounds like the constraint is your backup location. 10 G is pretty tiny these days.

You could copy your backups to a tape rotation so current backups exist in 2...

How about swtiching to Full recovery and taking regular T-log backups ? You may not need the recoverability, but it might manage your t-logs better.

What sizes are the databases ?

How critical are the databases ? For my prod dbs, I backup logs every 15 min or so.

How much space do you have to store...

Mad-Dog (5/16/2010)

---

i wrote that i want to fire the 3 min proc inside the 2 min schedule sql agent job but the proc will not interfere with the 2 min...

joemai (5/13/2010)

---

I normally do this:

- Create the exact same table structure with the original one and give it new name

- Copy only data that you need only over to this...

You could run something like this to look at the backup history and verify the files used for the restore match your backups.

SELECT sysdb.name, bkup.description, bkup.backup_finish_date,

case

when...

I do something similar, updating old records to set IMAGE data to NULL to free up space. It's fairly slow, but it can run 24/7 without affecting anyone.

Add your own...

I think that when you create the subscription, you also create & schedule the pull or push of the snapshot. (I haven't used replication in a while)

Nothing jumps out. It's not something silly like you're path is to the TRN files but you're specifying BAK files ?

I have not used "include fist-level subfolders". Is it...

Worked ok when I just tried it: 9.0.4053

Maint plan wrote a backup to a UNC path, then deleted from the same UNC path.

So if everything else is exactly the...

Why didn't you just use detach, move, attach ?

If the issue is in SQL code, you can use COLLATE to convert one to the other:

select * from DB_CollationA..TableA A

join DB_CollationB..TableB B on A.Fld1 = B.Fld1 collate Latin1_General_BIN

I assume blocked by t-log backups accessing the same tables .... Haven't verified it though.