Announcement

Collapse
No announcement yet.

Robocopy and Live SQL database

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Robocopy and Live SQL database

    Howdy!

    Anyone use Robocopy for delayed (say 2 hour) live backup of live SQL database (Mimer SQL). I'm sure it can be done but how do you force copy some of the database files if they are locked?

    I want to mirror our server at a co-location..well currently am but not the Database..it won't copy the open files.

    Any suggestions would be much appreciated

    regards

    A

  • #2
    Re: Robocopy and Live SQL database

    Schedule a backup from within the RDBMS, then use robocopy to copy the backup file to the other site.

    I'm not familiar with Mimer but SQL server can certainly do this
    Tom Jones
    MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
    PhD, MSc, FIAP, MIITT
    IT Trainer / Consultant
    Ossian Ltd
    Scotland

    ** Remember to give credit where credit is due and leave reputation points where appropriate **

    Comment

    Working...
    X