| 
	
 | 
 Posted by David Greenberg on 12/31/07 08:35 
Hi 
We usae Sql2000. 
I'm setting up backups jobs and need advise. 
When I run a backup of a database, does it automatically clean out the  
transaction log ? For a complete backup ? for a differential backup ? 
When would it be best to run a shrinkdatabase command ? Why would I want  
to run the shrinkdatabase ? 
Thnaks 
David Greenberg
 
  
Navigation:
[Reply to this message] 
 |