You will need to take a backup first regardless - if there is no space on the local disk use a UNC Share to  backup to another drive on the...

Yeah - this is a very common problem.  Its a bug and there is no need to panic .  Just change the view to...

Thanks Steve - that was exactly what I was looking for.

 Hi shaji09,

What are you doing upgrading to windows 2003 and not upgrading to SQL 2000.  Prob a good idea to upgrade to...

yes use a UNC share.  The server you are backing up to - is that on the same domain as the DB server.  Is your SQL Server running under a domain...

Open EM --> DB -->security-->right click linked server-->new linked server.  Its pretty basic from there

thanks guys,  Yes made the changes to the Boot.ini.

WINRAR - is a good option.  You could break the winrar into 50MB chunks and then FTP then over.  I have transfered 40GB DB's like that to remote locations and it...

you could also created a linked server through EM or use the sp_addlinkedserver SP and then use the OPENQUERY - something like

SELECT *

FROM OPENQUERY(SERVERNAME, 'SELECT *  FROM TABLE_NAME')

Yes, Staying on the thread

Agreed - I don't use EM very often - generally just to use the taskpad view to keep an...

Have you made changes the the Maint Plan after setting it up, that could cause it not to delete the old .trn?  Also if you execute the job through SQL...

Hello Chris,

I have tried your suggestion a few times and it works for a while and then I get the same error again.

Have not had a response from anyone.  Please let me know if anyone has any thoughts on this. 

Thanks,

Vik.

Hi Ray,

Please see above for details - no, my trans logs is fine and is backing up every hr and the size is now normal ( growing to 100 MB...

Nope, I just backed up the trans log.  Anyone got any ideas on this?