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 SQL safe Freeware Edition to backup my server(s)?

April 26, 2017backup edition freeware s safe server sql

0

Posted

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

1 Answer

0

Posted

Using SQL safe 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: SQL safecmd backup For example: SQL safecmd backup northwind c:\backup\northwind.safe SQL safecmd backup northwind c:\backup\nw_%timestamp%.safe For a complete list of all command-line parameters, please refer to the CLI Guide found in the Start > Programs > Idera > SQL safe > 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 @Returnc