|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 946
|
How do I restore backups?
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 417
|
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.
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 946
|
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" ?
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 417
|
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.
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 946
|
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
|
|
|
|
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).
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 946
|
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
|
|
|
|
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 DatabasesConsiderations for Backing Up the master Database
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 417
|
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?
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 946
|
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
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 417
|
Would executing something like this after database restore would solve the problem: http://support.microsoft.com/kb/246133?
|
|
|
|
|
