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 restore a database using SQL safe Freeware Edition?

database edition freeware restore safe sql
0
Posted

How do I restore a database using SQL safe Freeware Edition?

0 CommentsAdd a Comment

1 Answer

0

Using SQL safe Freeware Edition, you can restore a database in the following ways: • Perform an adhoc restore using the command-line interface • Perform an adhoc restore using the extended stored procedure (XSP) • Perform a regularly scheduled restore by creating a SQL Server Job To perform a restore 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 restore For example: SQL safecmd restore 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 > SQL safe > CLI Guide To perform a restore 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_re

0 CommentsAdd a Comment
What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.