November 8, 2014 at 10:20 am
hi all
How to Backup or copy From hole SqlManagement and Restore to Another Computer?
If there is a soloution I need to know.
if no way then my question is:
There Is instance of sql ,When i Backup from it ==>Task/Backup/Full backup and save from Device
I can not to restore that ...
Please Help me,Its important to me.
Tnx
November 8, 2014 at 10:39 am
Take backup from SSMS
Copy backup file to other server
Restore backup.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 8, 2014 at 11:08 am
It really is just that simple. It's the way I used every time. The only thing to watch for is if you have SQL Server logins for the database. When you restore the database to another server, whether you create the logins or already have them, the SID of the users in the restored database won't match the SIDs of the logins. Windows logins will be fine if the servers are on the same domain, but the SQL Server logins will need fixing. This page http://technet.microsoft.com/en-us/library/ms174378%28v=sql.90%29.aspx will help you fix them.
November 8, 2014 at 1:17 pm
thanks For Ur COmment ..
How To Backup SSMS >?
Can U describe That ?
Tnx
November 10, 2014 at 5:28 am
ahfb (11/8/2014)
thanks For Ur COmment ..How To Backup SSMS >?
Can U describe That ?
Tnx
SSMS is software installed on a computer. If you have the installation disk, you can install it whenever you need to. If you're trying to back up your server registrations, see http://msdn.microsoft.com/en-us/library/ms190246%28v=sql.90%29.aspx for instructions on how to do it.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply