Recent content by ledzepe

thank you SQLSister, i work for a freight company and do to an effective search we always need a date range, origin, destination and shipper so that's 5 fields already. we need more fields to really narrow down the search. i will bring up the small search and big search option that you mentioned...

hello everybody, i would just like to solicit your opinion on wheather or not our consultant is telling us the truth or just taking us for a ride. i am not well verse on sql. we have a win2003 server running sql2000 and they made a search program so that we can find stuff on the database. our...

Thanks Swi, I also made something similar but your code's a bit more elegant than mine.

Hi all, I a newbie with vbs and this question might have been asked a million time already. I need to search a folder/directory for all the pdf file and (1)list them in a text file, (2)display on screen how many pdf and then (3)move them to a different directory. Thanks a million.

Yes, it should be in the router.

What's your network config like? Do you have a separate network for backup?

SQLBill, Yes, silly me... I found out after writing this thread that overwrite isn't turned on... Thanks anyway....

We changed our backup schedule on our server from full daily backup to incremental daily because of capacity issue. Now the problem is it won't take the daily tapes that we've used before for our full daily backup. The error it was reporting is that the tape is already full.

How about giving us a sample of the log...

Solved it! Backup on two tapes won't work because I found out that we are backing up 60GB of compressed data therefore in effect we have more than 360GB of data. I excluded the 60GB compress and got the backup going.

THANKS ALL ... I got our Saturday Full-backup going without error. I analysed the data we are backing up and it turned out that we are backing up 60GB of compressed data. Therefore two tapes (100/260GB) won't hack it. I read somewhere in this forum that the first number in the backup tape...

My understanding of Overwrite Protection Time is the time from the last write to the time when the tape (or part of the tape) can be over written. If my Overwrite... is set to < 1 hour and let's say the drive wrote a new file on the tape at 3:00AM, the file can be overwritten after 3:59AM...

We have changed or added or deleted anything on the backup server. Its just that 3 Saturdays ago , it stops writing on the second tape and I'm doing the very same daily/weekly routine. We uses two tapes for our Saturday full backup since we have 300 GB to backup. Below is part of the log where...

SQLBill, Thanks for the advise, in fact its one the setting we plan to change this weekend.

Hi madmarco, What did you mean with &quot;>>>>>>This 1st tape again!&quot; ? We uses two tapes for our &quot;Saturday full weekly backup&quot; and we backup approximately 300GB. AAY602 is the first tape of the series and AAY601 is second tape. As soon as AAY602 is full, the tape drive picks...