You cannot use UNC paths in a CMD window.

Try mapping the UNC path as a mapped drive or use SSIS with a file system task.

holiday

Can you detail how PBM will stop insert updates and deletes happening to a DB?

Detach the database and copy the mdf/ndf/ldf's some where else

Yep, use the edition which does what you need, if you can do what you need in Standard then use Standard, if you need features from BI or Enterprise, the...

Speak to your MS Reseller or MS directly as to the cost as depending on your aggrements the price may differ and will differ if you want SA and other...

Set the database to read only,

Deny insert update delete to the users, then re-enable it (only works if security is managed properly and the accounts dont have elevated rights)

Set...

Does the table have a clustered index? If so rebuild the clustered index.

If not, you cannot resolve table fragmentation until a clustered index has been created.

I stand corrected on...

Is it that the trigger is fireing after the delete therefore the deleted row doesnt exist any more in TTASK, and a before delete trigger will be the way to...

Running a database in a different versions compatability mode doesnt make the DB a that particular modes type of database.

Compatability level provides partial backwards compatability only certain things will act...

Can you post the query?

Bad idea, you should be backing up every 30 minutes to a new file, not to a big file for that particular day, as should anything happen to that file,...

Use a for each loop with the transverse subfolders option set and then you can change the connectionstring of the csv connection manager dynamically.

Grant the user db_datareader,

But remember DENY takes over a GRANT, so if there is an explicit deny on the object they wont be able to select from it.

Check for any deny's in sys.database_permissions for the object and user in question

Deny will take over a Grant