Results 1 to 12 of 12

Thread: SQL Hot back up

  1. #1
    Join Date
    Sep 2008
    Posts
    4

    SQL Hot back up

    How Can I stop the ms sql to write disk for a while . I don't want to stop service I want to use another temrorary device to write continuous data.
    I want to make backup program for storage units when To make it consistent I have to make MS sql to vdi mode (?) . How can I achive that ?

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Why don't backup db with sql backup statement? It's online operation.

  3. #3
    Join Date
    Sep 2008
    Posts
    2
    take that db offline. it will error out but would not write to disk.

  4. #4
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    If you are looking for something like ALTER DATABASE BEGIN BACKUP in Oracle, then it is not available.

    Putting database offline or read only may work, but you may have to kill any active connections.

  5. #5
    Join Date
    Sep 2008
    Posts
    4

    hot back up

    I want to stop writing to backup with 3rd party application.

  6. #6
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Can you clarify?. Are you using third party backup software that is backing up SQL database?

  7. #7
    Join Date
    Sep 2008
    Posts
    4

    Message

    I want to make new application for backup
    I used VDI examples that worked but it is very complicated . I have to make new class to use c++ application in my c# code

  8. #8
    Join Date
    Sep 2002
    Posts
    5,938
    You want to write your own db backup app for sql server? Why have to stop writing to db? Backup should be online process, who will use it otherwise?

  9. #9
    Join Date
    Sep 2008
    Posts
    4

    Sql

    Because I want to take snapshot of complete disk . To make it cosistent I have to stop DB to write disk. It can work on memory to accessibility.

    I don't now really how database working or what is transaction. There is Documantation about this here : http://www.microsoft.com/technet/pro...sqlwriter.mspx

    They write a lot of thing but nothing about code.

  10. #10
    Join Date
    Sep 2002
    Posts
    5,938
    You can't access sql db in memory if it's down.

  11. #11
    Join Date
    Sep 2008
    Location
    CT
    Posts
    3
    Quote Originally Posted by halidziya
    Because I want to take snapshot of complete disk . To make it cosistent I have to stop DB to write disk. It can work on memory to accessibility.

    I don't now really how database working or what is transaction. There is Documantation about this here : http://www.microsoft.com/technet/pro...sqlwriter.mspx

    They write a lot of thing but nothing about code.
    The MS SQL engine is always writing to either the transaction log or the database itself. You would almost need to detach the DB from the service to halt all that I/O so that the "disk image" software you want to develop can function.

    The preferred method is to have the MS SQL engine create a BACKUP file (.BAK) - this is done while users are on-line and really captures the "snapshot" of that moment in time. When you restore from that .BAK any "transaction" that were in process and not yet committed are rolled back automatically - thus making it a truly hot backup.

    Commercial backup tools have SQL agents that assist the backup in handling the always open database and transaction files.

  12. #12
    Join Date
    Sep 2008
    Posts
    1
    There is a 3rd party SQL Server backup tool (litespeed) which can be used as an alternative to the standard MS one.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •