I haven't been on 2000 in a little while, but I think you can script out all the objects from your production database to a single .SQL file. Then create...

Rather ironic that the OnlineExam database didn't get backed up.

Going forward, you can run something like this to identify databases that have not been backed up recently:

select * from master..sysdatabases...

jchen (8/25/2008)

---

I will migrate db to a new envirentment by sql server 2k5. I need to estimate what hardware and sofware which I need for migration. Here is my configuration...

jchen (8/25/2008)

---

I got one DTS job failed, it showed me below error, how can I from this error to drill down exactly failed reason. Can you help?

Thank you,

PS:

The job...

Go here:

http://www.sqlservercentral.com/Forums/

Then post in the most appropriate section ... ie,...

When I used replication across domains, I created a Windows account on each server with the same name & same password.

I had a similar problem. I loaded Windows XP pro on my laptop instead, then installed SQL 2005 developer edition.

This sounds a bit like a generic homework assignment ..... so here's a generic answer

1) Copy records older than 6 months into archive tables.

insert into Archive_table select * from Prod_table

where...

Adam Bean (8/22/2008)

---

sayfrend (8/22/2008)

---

Thanks homebrew ,

I guessed its because of DTS packages... Its really wierd though, it means when ever you are working on DTS packages you cannot use SSMS...

Are you running a maint plan that deletes the previous backup ?? If so, then the space problem is caused by the fact that the old backup is not...

Even though you can't browse to the path to select it, you can use Copy-Paste to enter the path you want.

Could you just add a DOS copy command as the next step in your backup procedure ?? I used to do something similar.

Legacy DTS does cause some odd behaviour when it's open. I've experienced problems similar to yours, but they clear up when I close DTS.

I just used a regular .BAT file executed in a Scheduled SQL Job.

Step 1, Backup the DB.

Step 2, Copy the .BAK to another location. Either using...

Wasn't there a problem with the Maint Plan Cleanup Task not working correctly ?? I think I heard that SP2 fixes that.