laravel-backup icon indicating copy to clipboard operation
laravel-backup copied to clipboard

Add support for SqlServer

Open nadinyamaui opened this issue 10 years ago • 0 comments

Doing sqlserver backup is quite simple you just have to execute

BACKUP DATABASE { database_name | @database_name_var } TO <backup_device> [ ,...n ] [ <MIRROR TO clause> ] [ next-mirror-to ] [ WITH { DIFFERENTIAL | <general_WITH_options> [ ,...n ] } ] [;]

http://msdn.microsoft.com/es-ve/library/ms186865.aspx

And the same to restore database is very simple to do. just run the next sql

RESTORE DATABASE { database_name | @database_name_var } [ FROM <backup_device> [ ,...n ] ] [ WITH { [ RECOVERY | NORECOVERY | STANDBY = {standby_file_name | @standby_file_name_var } ] | , <general_WITH_options> [ ,...n ] | , <replication_WITH_option> | , <change_data_capture_WITH_option> | , <FILESTREAM_WITH_option> | , <service_broker_WITH options> | , <point_in_time_WITH_options—RESTORE_DATABASE> } [ ,...n ] ] [;]

http://msdn.microsoft.com/es-es/library/ms186858.aspx

nadinyamaui avatar Aug 13 '14 17:08 nadinyamaui