How to restore MS SQL database?

  • I reinstalled a cursor of Dle 8.2 and I removed a database. It is possible to restore somehow? in dbconfig.php provided the names of the bases, there was on the server. The old base was removed and it happened that overwrote the base.

  • baldwin 38894 (5/3/2015)


    I reinstalled a cursor of Dle 8.2 and I removed a database. It is possible to restore somehow? in dbconfig.php provided the names of the bases, there was on the server. The old base was removed and it happened that overwrote the base.

    DataLife Engine is written for MySql, to my knowledge it hasn't be ported to SQL Server so frankly this is the wrong place to ask this question.

    😎

    Few more points, do you have any backups? What OS are you running on? What FS are you using?

    Also consider uprating to 10.4 (current), the 8.2 is known to be insecure (wide open).

  • You can, if the logs are conducted. Still need a backup at some date + binary logs from this date... (from "for performance reasons" - they usually turn off).

    Your actions:

    1)need a backup of the database for some date: date1

    2)the base is removed in date: date2

    3)mysqlbinlog -s -d db_name -u user_name --start-datetime="date1" --end-datetime="date2" -t mysql-bin.[0-9]* > out.sql

    4)restore the backup database for date1

    5)add the inquiries from a binary log in the interval date1 date2...:

    mysql db_name < out.sql

    Or try to restore using Recovery Toolbox for SQL Server. This is a very strong utility and repairs efficiently and quickly. Can use. https://sql.recoverytoolbox.com/[/url]

  • You can, if the logs are conducted. Still need a backup at some date + binary logs from this date... (from "for performance reasons" - they usually turn off).

    Your actions:

    1)need a backup of the database for some date: date1

    2)the base is removed in date: date2

    3)mysqlbinlog -s -d db_name -u user_name --start-datetime="date1" --end-datetime="date2" -t mysql-bin.[0-9]* > out.sql

    4)restore the backup database for date1

    5)add the inquiries from a binary log in the interval date1 date2...:

    mysql db_name < out.sql

    Or try to restore using Recovery Toolbox for SQL Server. This is a very strong utility and repairs efficiently and quickly. Can use.

    https://sql.recoverytoolbox.com/[/url]

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply