Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
New Topic Post Reply
Restore backups Options · View
Previous Topic · Next Topic
Guest
#1 Posted : Thursday, August 13, 2009 1:15:42 AM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 253
How do I restore backups?
Back to top
  |
ruslan
#2 Posted : Thursday, August 13, 2009 1:16:04 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/10/2009
Posts: 141
Use One-Click SQL Restore - it is the simplest way to restore backups.
SqlBackupAndFTP creates a standard backup file that can be restored using One-Click SQL Restore or RESTORE DATABASE statement (see http://msdn.microsoft.com/en-us/library/aa176746%28SQL.80%29.aspx) or through SQL Server Management studio "Restore" option. Here is a good walk-through.
If you have used scripting for remote database - just run the script files.
Back to top
 Report Abusive | Report SPAM | Edit by user: Wednesday, September 01, 2010 2:40 PM | Reason: Not specified
Guest
#3 Posted : Thursday, September 10, 2009 12:21:33 PM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 253
ruslan wrote:
SqlBackupAndFTP creates a standard backup file that can be restored using RESTORE DATABASE statement or through SQL Server Management studio "Restore" option.
If you have used scripting for remote database - just run the script files.



We plan on using for backing up our BlackBerry server. I do not know anything about SQL other than it was installed with our BlackBerry server.

What is, and how do I restore with the "RESTORE DATABASE statement" ?
Back to top
  |
ruslan
#4 Posted : Thursday, September 10, 2009 4:12:22 PM Quote
Rank: Administration

Groups: Administrators

Joined: 8/10/2009
Posts: 141
In short, just install One-Click SQL Restore on the same server, open a backup file and click button Restore.
However you may be better off leaving RESTORE operations to a person who knows SQL Server sufficiently enough not to destroy your data.
Back to top
 Report Abusive | Report SPAM | Edit by user: Wednesday, September 01, 2010 2:26 PM | Reason: Not specified
Quick Reply Show Quick Reply
New Topic Post Reply
Forum Jump  
You can post new topics in this forum.
You can reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You can vote in polls in this forum.