Duplicate posting mate, please post it in one Forum 🙂

Hi

What is that script that is asking for SA log in to run, 😉

Hi

How many records are we talking here, are all this 28 tables are in same database. 🙂

Thanks Lowell, that's a nice plan :), will try that one

Out of curiosity, can i know the reason for restarting the service on a daily basics,

On the other hand, is there any code changes that have been made on...

hmm this is nothing to do with a recovery mode, if the database is on recovery mode then its trying to completed some uncompleted business before restart? is this a...

Hi Shri

How many days of back up do u hod currently?? and is all previous days back...

Good point 😀

Express is free, why not try installing it and have it a go 🙂

Not sure mate about graphs in Express mate

you can also use activity monitor to see blocked transactions, or Performance dashboard to get live reports of locks and blocks 🙂

What mode is it once the SQL service has been restarted?, is SQL service takes a long time to restart??

We are using JDBC1.2 it works fine( According to developers) but it doesn't support Filestreaming, jTDS seems that it doesn't support BLOB, correct me here if i am wrong.

Hi Erik

I am about to test that theory, i am having a production serer where i got videos and images...

when you are not able to access data from the database, in case server is fine

Saying this , this is a open end Question what exactly are they looking for...

Thanks Manu

That's a nice plan, i dint want to install an upgrade...