Integrity checks run if the database is set to a single user. If there is any active connection, then the integrity check fails. Run the backup after killing any remaining...

Agree with all of you. option 2 is the most practical way to do it. You can set DTS jobs to move the data to those individula dbs, which will...

Thank you. Rebooting the server did the trick. Still, I will profile to figure out what is going on there and will keep renaming tempdb and let the system create...

I do agree with SQL Lite assesments as well as the notes regarding maintenance plans.

We are testing the product and it does help a lot.

Space and speed wise...

Thank you all. With all your input, I solve the issue and successfully implementd it. Thank you again.

Thank you. I added the print statement you recommended and it came back the same. What am I doing wrong?

Thanks Antares. That was the solution. I did create a VB dll and that gave the answer. Thanks again

That could work if the clients start sending those files daily, but some times they send their files one or two days later and the date will be something different...

Just another note to contribute with this matter.

If the table is to large any changes you make is going to take a toll in your database. What I will do,...

I am interested in this position. I am forwarding my resume to the e-mail address mentioned. I lived in Colorado for quite some time. I am currently working in TN,...

Thank you.

That was my first approach. Log shipping or replication, but the problem is that some databases come in their original format and then translated into SQL.

There are...

I run quite a few DTS jobs every morning and at one time we have a similar issue. We receive zip files from the clients and those files have to...

At your IIS machine, have you tried to create a SUer or system DSN? I will try that to see if your web server is being able to connect to...

Thank you. Log shipping was one option I couldn't use because we do not have Enterprise. Thank you very much. That will help a lot.

Thanks again Greg. Again, what I need is the way I can create the schedule using T-SQL.

Like:

RESTORE DATABASE MyDB

FROM MyDB_BAK

@active_start_date = 20020805, @active_start_time = 0, @freq_interval =...