Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How do I use SQLsafe Freeware Edition to backup my server(s)?

April 26, 2017backup edition freeware s server sqlsafe

0

0 Posted

How do I use SQLsafe Freeware Edition to backup my server(s)?

1 Answer

0

0 Posted

Using SQLsafe Freeware Edition, you can backup a database in the following ways: • Perform an adhoc backup using the command-line interface • Perform an adhoc backup using the extended stored procedure (XSP) • Perform a regularly scheduled backup by creating a SQL Server Job To perform a backup using the command-line interface, do the following: • Open a command prompt window. Select Start > Run, type ‘cmd’, and select OK • In the command prompt window, enter the following: Sqlsafecmd backup For example: Sqlsafecmd backup northwind c:\backup\northwind.safe For a complete list of all command-line parameters, please refer to the CLI Guide found in the Start > Programs > Idera > SQLsafe > CLI Guide To perform a backup using the extended stored procedure (XSP), do the following: • Open Query Analyzer or SQL Server Management Studio • Enter the following: DECLARE @Returncode int EXEC @Returncode = [master].[dbo].[xp_ss_backup] @datab