Hi,

Just tried it by increasing the initial size values by 1MB and it does indeed change the modified date on the files.

Thanks so much for the help.

🙂

That's a great idea.

Will give it a try tomorrow. 🙂

Thanks.

I was just hoping that there would be a way of issuing some kind of checkpoint which may result in the modified date of the ldf file updating, and eventually...

Hi

Thanks again for the info.

It's not that I'm in any situation as I'm as sure as I can be that the files are in the correct locations and that the...

Hi George

Thanks for the reply. Regarding sysfiles, this doesn't seem to return the name of the files that are being used to write to at this moment in time. If...

Thanks for the suggestion. I'll raise it with the development guys and see if it's workable. Hopefully it will be - if so, I'm sure the performance will be significantly...

Possibly not. I'd have to discuss it with the development guys in charge of the app.

If we did go down the route of one set of tables for all customers...

Thanks for the suggestion. With that though, would I not have an issue if I needed to restore a particular customer's data from a point in time?

Point taken about restores if all the data is stored in one set of tables.

Regarding partitioning, I thought you were thinking of partition functions/schemes if all the data was in...

Hi,

It isn't necessary to duplicate all system tables for each client.

It isn't necessary either to duplicate the user tables, so all data could theoretically be held in the same 30...