Who is the owner of this job? If its not sa then read about creating proxy accounts at http://technet.microsoft.com/hi-in/library/cc966397(en-us).aspx

MJ

How to transfer logins and passwords between instances of SQL Server

http://support.microsoft.com/kb/246133

MJ

It would be gud if you install client tools and register the instance from there.

MJ

Restore basics: How to restore using T-SQL commands

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1173442,00.html#

MJ

Do you see any win rar process exe under Task manager-->Processes-->Image Name column? If yes, then kill it and you will get your file freed from zip process(make sure there...

You don't need to switch on AWE. However it is recommended you grant the SQL

service account the "Lock Pages in Memory" right (you can do this by going

to...

What is the result of select serverproperty('productlevel'),serverproperty('productversion') on your problematic server?

MJ

SQL Server 2005 does not have to be performing a particular server role in a database mirroring session when you apply a service pack or a hotfix. For example, SQL...

Step-by-Step Guide to Reverse Engineering a Database in Visio 2000

http://msdn.microsoft.com/en-us/library/aa140264(office.10).aspx

MJ

Yes, use the sys.indexes catalog view instead.

http://msdn.microsoft.com/en-us/library/ms190283.aspx

MJ

You need to stop tht trace first http://support.microsoft.com/kb/822853

and then you would be able to delete the files.

MJ

I think that can be done only after checking their versions.

MJ

Have you tried Lumigent Log Explorer?

MJ

http://msdn.microsoft.com/en-us/library/ms188748.aspx

CHECKPOINT (Transact-SQL)

Writes all dirty pages for the current database to disk. Dirty pages are data pages that have been entered into the buffer cache and modified, but not yet written...

Get some ideas from http://www.sqlservercentral.com/Forums/Topic504330-338-1.aspx

MJ