Suggested maintenance scheduling of ms sql db ???

Discussion in 'Databases' started by cbecker6969, Sep 1, 2005.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. cbecker6969

    cbecker6969

    Hello,

    I am hosting my first mssql db. Our company gets daily new data from site that is critical to keep backup.Can anyone suggest what is the best approach for scheduling the pulling of data from live to local?I am not sure what the download time will beorsize yet. WhenDTS job is executing do my website users lose DB functionality till job is over?Is there user downtime during pull?

    Thanks in advance.

    Christian
     
    cbecker6969, Sep 1, 2005
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    SQL is a transactional database. it should function fine even when a DTS package is running.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Sep 1, 2005
    #2
  3. cbecker6969

    cbecker6969

    Thank you for your reply. So i can pull from live to local as often as even hourly for example and it should function fine.Can you offer any advice on DTS scheduling? For example how do some of your other clients schedule their critical data to save to local.? Any comments are most appreciated.

    Christian
     
    cbecker6969, Sep 1, 2005
    #3
  4. Bruce

    Bruce DiscountASP.NET Staff

    for security reasons, we cannot schedule DTS package on our server. You'll have to schedule the package on your server to pull from the server.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Sep 2, 2005
    #4
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page