Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
Restore backups Options · View
Guest
#1 Posted : Thursday, August 13, 2009 1:15:42 AM
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 1,016
How do I restore backups?
ruslan
#2 Posted : Thursday, August 13, 2009 1:16:04 AM
Rank: Administration

Groups: Administrators, Registered

Joined: 8/10/2009
Posts: 430
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.
Guest
#3 Posted : Thursday, September 10, 2009 12:21:33 PM
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 1,016
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" ?
ruslan
#4 Posted : Thursday, September 10, 2009 4:12:22 PM
Rank: Administration

Groups: Administrators, Registered

Joined: 8/10/2009
Posts: 430
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.
Guest
#5 Posted : Monday, June 20, 2011 5:19:38 AM
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 1,016
Hi

Its one thing to backup databases but what about users.
This program would be brilliant if it could backup the users and restore them as well. Can it do that?

Regards
Dave
mikeshilov
#6 Posted : Tuesday, June 21, 2011 2:11:59 AM
Rank: Administration

Groups: Administrators

Joined: 8/12/2009
Posts: 271
Guest wrote:

Its one thing to backup databases but what about users.
This program would be brilliant if it could backup the users and restore them as well. Can it do that?


The program performs BACKUP DATABASE command which (as i know) does BACKUP DATABASE users (but not server logins).
Guest
#7 Posted : Tuesday, June 21, 2011 4:11:07 AM
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 1,016
We are hosting company and looking at products that can backup databases and users to an off-site system for DR purpose.
In this situation getting the users (as in logins) is also important.

Thanks
Dave
mikeshilov
#8 Posted : Tuesday, June 21, 2011 4:19:14 AM
Rank: Administration

Groups: Administrators

Joined: 8/12/2009
Posts: 271
Guest wrote:
We are hosting company and looking at products that can backup databases and users to an off-site system for DR purpose.
In this situation getting the users (as in logins) is also important.


Logins are stored in master database so you may include it into backup if you need. Please look at these articles:
Considerations for Backing Up and Restoring System Databases
Considerations for Backing Up the master Database
ruslan
#9 Posted : Tuesday, June 21, 2011 10:20:12 AM
Rank: Administration

Groups: Administrators, Registered

Joined: 8/10/2009
Posts: 430
Dave,
are you talking about restoring orphaned users using sp_change_users_login?
You can find these users using
EXEC sp_change_users_login 'Report'

Then you can try to fix it using
EXEC sp_change_users_login 'Auto_Fix', 'UserName',NULL, 'FakePasswordToBeIgnored'
Since you don't know the password, this would only work for users who already exist on the target server.

Is this the functionality you would like to see in One-Click SQL restore?
Guest
#10 Posted : Tuesday, June 21, 2011 7:16:34 PM
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 1,016
Hi,

Thank you for your replies.

Yes we currently script the users to output to a text file which is included in the backup however this could cause issues on the target server at restore time due to orphan problems and other related issues we have seen in testing this on our systems, we know its possible to get users and have done so many times before however It would be great to have this incorporated into SQLBackupAndFTP program. Perhaps an addtional license fee for providers to have that ability, we would certianly pay extra to have that.

One-Click SQL restore would be awesome if it had the ability to restore users and match them up with the databases on the target. In our situation it would be a complete restore of all databases on the server, not restoring a few databases to a server that already has databases on it.


Regards
Dave
ruslan
#11 Posted : Thursday, June 23, 2011 12:08:19 PM
Rank: Administration

Groups: Administrators, Registered

Joined: 8/10/2009
Posts: 430
Would executing something like this after database restore would solve the problem: http://support.microsoft.com/kb/246133?
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You can create polls in this forum.
You can vote in polls in this forum.

©Pranas.NET Sql Server Backup MySql Backup Free SQl Backup SQL Backup Master Employee monitoring software Web Scraping Azure SQL Database Backups ergonotes.com