yulichka (11/12/2008)

---

Thank you for your help, I don't have mobile users. I would need to compare two servers staging and production, if there is any changes with data in production,...

Redgate makes tools to compare the databases, but I don't know if it will also apply the changes. How about using replication to keep them in sync ?

[font="Courier New"]SELECT Job.[name], Hst.[sql_message_id], Hst.[message] , Hst.[run_date], Hst.[run_time], run_duration

FROM [msdb].dbo.sysjobhistory Hst

INNER JOIN [msdb].dbo.sysjobs Job ON Hst.[job_id] = Job.[job_id]

where convert(varchar(8), GETDATE()-1,112)= Hst.[run_date]

and name not...

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 ?