Hi, I think you could use the DBCC SHRINKFILE , this shrinks the log file by removing as many virtual log files, that the files that are not in use....

thanks, we have shrinked the log. but I would like to know the possible causes for the sudden raise in the log size!:) any suggestions or tips I could check?...

Hi, This error occurs when distribution agent attempts to update a row at the Subscriber level, but the row has been deleted or the primary key of the row has...

what is the application you are using? suppose you dont have access to the database?

incorrect synatax means the query you are trying to execute through the application is wrong. You...

further,

Do you have replication active?--> No

Do you have database mirroring?-->No

thanks!! could you tell me where to get 'WaitFor.exe', (any website where I can download) and how to implement?

thanks for the reply!!:) it was helpful for me to understand the recovery and no recovery options!!

The result gave : dataname,FULL,LOG_BACKUP

In the query : SELECT name, recovery_model_desc, log_reuse_wait_desc from sys.databases

what does 'log_reuse_wait_desc' --mean?

could you please paste the error that you are getting now?

move syntax -> moves the data and log files to their respective drives, this is the case when you...

We have a Full backup taken daily at 11pm , differential backup every 2 hours a day, and transactional backups every half hour through the day

its a test server environment,...

I didnt really understand the query :

select physical_device_name from dbo.backupmediafamily

could you explain? and can I try it too? 😉

thanks

You could also go in for a TSM backup procedure!!:P

Hi,

Here is a brief explanation:

The Full Recovery model uses database backups and transaction log backups to provide complete protection against media failure. If one or more data files is damaged,...

Hi, I think you may be having some permissions issue...not sure though!:)

thanks Gail;)