yes it can happen. as you DB is set to FULL Recovery mode.. Everythign is logged in the LDf File..

if the compatibility is set to 80 then yes you can move the database to 2000 if not.. then NO. as per my understanding.

Or create a new database on 2000...

sqlbuddy123 (6/26/2009)

---

Hi Mani Singh,

Thank...

Could anyone tell me how to execute (with an example if possible) the 32-bit legacy DTS packages that were copied from a 32-bit SQL Server 2000 instance to...

I am not using this but here are some links:

http://msdn.microsoft.com/en-us/library/zcc9cwax(VS.80).aspx

http://msdn.microsoft.com/en-us/library/s0fk6z6e(VS.80).aspx

http://msdn.microsoft.com/en-us/library/ms165034(VS.80).aspx

as far as i have it: the principal has the VIEW SERVER STATE permission to use the any AUDIT DMV

if you Just change the datatypes in the database tables.. everything should work.. if you have specifically specified any convert to nvarchar etc.. you will have to change your declares...

Rajesh: if there are transactions happening on the server and going through tempdb, it will not work.. tempdb has to be in quite mode(single user) or there should be no...

as said before check the broker status and also you can stop and start dmail and send again to check if it works....

It shouldnt be a problem. SQL server uses as much as it needs and with the kind of RAM , it is happy...

Are you running X64 or x32 and is...

try DML or DDL Triggers..

Also you can use profiler to keep track of who doing what or server side traces....

some kind of component or dll failure to load or something..

try updating to SP3...

Differential backup if the changes from the most recent full backup and not the last diff backup.

So you restore the latest full backup and the recent diff backup... correct me...

something to try:

Try from a diff client or Try logging/remoting onto the server itself and then try again:

I hope you know what i am talking about.

EDIT: is you server...

check to see if the SQL express is installed with the OPS manager. then it should have a diff SP