It might help to say what the error is

I think you need to declare @maxno inside the dynamic sql

I would take a FULL backup as a precaution, then use detach/attach. It's probably faster since you bypass the backup & restore steps and only need to do the file...

Not directly relevant, but when converting MySQL to SQLServer, I used SQL_Maestro as an interface to dump out the tables for import into SQL .... FWIW

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...