Are all the SQL Services running ?

If there aren't too many, you could save them to the new server.

Open the package, "Save As", Maybe prefix the name like "OldServer_DTS_Name", then save it to the new server....

TRACEY (11/7/2008)

---

Are you moving sql 2000 db to sql 2005.

If so just do backup and restore....no need to do system databases they are different in SQL 2005.

Just go get the...

What change to the database ?? That might help direct the responses.

Did you determine the count of 19,410,958 by using rowcount, or by "right click" -> "Properties" ?? The "properties" is not always accurate.

madhu.arda (11/6/2008)

---

Ok..

What happens in below scenarios:

1.If mdf file exist and ldf file deleted can we do the point in time recovery?

2.If ldf file exist and mdf file deleted can we...

But if you're doing a lot of work in the database, either go FULL with T-log backups like a Production DB, or do more frequent FULLs while the work is...

But back up your table first !!!

Select * into TeamBase_20081106

from TeamBase

Then use the select statement to get a count of how many you will delete. When you delete, the count...

Correct. If you delete the entire database, then there is no database of which to take a backup, so you can only recover up to the last t-log before the...

Make sure you compare "apples to apples" if some tools have different versions such as Standard & Enterprise.

Also, get a real quote from each, not MSRP. Some will give discounts....

I do backups daily ....... better safe than sorry.

100 G in 20 minutes ?? You must have some huge transactions taking place. Did someone accidentally schedule index rebuilds to run all day long ?

Thanks !

"...

If you'll be keeping the same hardware, I would make sure that anything connecting via TCP/IP is confirmed...."

We're going to all new hardware, including a SAN to replace the...

I've used them both, and like the fact that Idera has object level recovery. Redgate does too, but you have to buy 2 additional products to make it work. ...

I think you need to restore only up to just before you deleted the table. If you restore the entire log, then you'll re-delete the table that you just restored....