Database full backup and restore command

Jak

Member

858 Points

132 Posts

Hi,

Please provide Database full backup and restore command.

Views: 8688
Total Answered: 2
Total Marked As Answer: 1
Posted On: 30-Oct-2014 03:39

Share:

Answers

Nice One Member 280 Points 0 Posts	Hi, Backup Command: USE master; ALTER DATABASE <DATABASE> SET RECOVERY FULL; BACKUP DATABASE <DATABASE> TO DISK=<backupfilepath> WITH FORMAT; BACKUP LOG <DATABASE> TO DISK=<backupfilepath>; Restore Command: USE master; RESTORE DATABASE <DATABASE> FROM DISK=<backupfilepath>with replace Posted On: 30-Oct-2014 04:59
Rahul K... Participant 292 Points 26 Posts	It's working for me. great ... Posted On: 15-Jul-2016 06:31