SQL Server Performance

Search Results

Search Again
  1. lenhilldba

    Stored Procedure for Closing Database/Tables

    Post by: lenhilldba, Jun 20, 2007 in forum: Getting Started
    Everyone, Here is my problem from the Backup Log :- 20070412 221956 2790 W3404 Unable to open file. (FILE=M:ACCESSDBARK_DATA.MDF, EC=SHARING...
  2. lenhilldba

    Stored Procedure for Closing Database/Tables

    Post by: lenhilldba, Jun 19, 2007 in forum: Getting Started
    Satya, Thanks for that. How do I ensure that these type of files are 'Closed' prior to any Backup Routine? rgds, lenhilldba
  3. lenhilldba

    Stored Procedure for Closing Database/Tables

    Post by: lenhilldba, Jun 19, 2007 in forum: Getting Started
    Adriann, I have a couple of tables TestLen.mdf and TestLen.ldf that give a 'Sharing Violation' whenever we carry out an ovenight backup. I'd like to...
  4. lenhilldba

    Stored Procedure for Closing Database/Tables

    Thread by: lenhilldba, Jun 19, 2007, 15 replies, in forum: Getting Started
    Hi, First Time at this. Can someone please tell me how to setup and activate a Stored Procedure to Close all Tables within a Database each night @...
Showing results 1 to 4 of 4
Search Again