1.take the full backup from ms studio
2.transfer the backup piece from source to target (i.e cmd prompt and c: or shared folder to target server.
3.
you may generate the script from msq sql studio alter this wherever you want to place the mdf,ldf files alter it based on the available disk space.
RESTORE DATABASE [DB__name] FROM DISK = N'E:\backup\DB__name_july28\DB__name_full_bakup.bak' WITH FILE = 1, MOVE N'DB__name_Data' TO N'E:\SQLData\DB__name.MDF', MOVE N'DB__name_Log' TO N'F:\SQLLog\DB__name_1.LDF', NOUNLOAD, STATS = 5
4.run dbcc to check the integrity of the database.
5.check all the user permission everything good.
6.fix the orphan user account using the below steps
EXEC sp_change_users_login 'Report'
2.transfer the backup piece from source to target (i.e cmd prompt and c: or shared folder to target server.
3.
you may generate the script from msq sql studio alter this wherever you want to place the mdf,ldf files alter it based on the available disk space.
RESTORE DATABASE [DB__name] FROM DISK = N'E:\backup\DB__name_july28\DB__name_full_bakup.bak' WITH FILE = 1, MOVE N'DB__name_Data' TO N'E:\SQLData\DB__name.MDF', MOVE N'DB__name_Log' TO N'F:\SQLLog\DB__name_1.LDF', NOUNLOAD, STATS = 5
4.run dbcc to check the integrity of the database.
5.check all the user permission everything good.
6.fix the orphan user account using the below steps
EXEC sp_change_users_login 'Report'
No comments:
Post a Comment