Viewing 6 posts - 46 through 51 (of 51 total)
Excellent indeed !!!
That solved the problem !!!:D
Thank you v e r y much Andras !
Is there a book that can be helpful in incidents such as this ?
Thanks again Andras...
October 22, 2007 at 5:53 am
Hi,
select name, size, maxsize, growth from dbo.sysfiles where fileid=2
yields
fiftyplus_Log ...
October 22, 2007 at 5:35 am
Hi Andras
Answer is:
size maxsize
128384
October 22, 2007 at 4:41 am
Sorry Andras for calling you "Mr or Mrs. 500" :blush: I got so confused with those errors.
Thanks connect_ninad. I ran
backup log with truncate_only
And got
Incorrect syntax near the keyword...
October 22, 2007 at 4:37 am
Hi Mr or Mrs. 500
I used your advise, ran the query and got the following message:
Processed 66 pages for database 'fiftyplus', file 'fiftyplus_Log' on file 2.
BACKUP LOG successfully processed 66...
October 22, 2007 at 4:30 am
Viewing 6 posts - 46 through 51 (of 51 total)