alessandro.feltrin (8/29/2015)
[font="Arial"]Hello. I need to implement a Lab environment and in order to do this i have installed a new Virtual Machine with the same configuration and Software releases.
I've performed a Full Backup of the application production DB using SQL Server Management Studio. The SQL Server is the 2014 Edition.
How can i restore this DB into the Lab machine? Using the "restore" function is enough? or is better to do something else in some other ways?
The application i need to start in the Lab Environment is BMC Remedy.
Thanks a lot
Alessandro
[/font]
Quick thought, using the RESTORE (Transact-SQL) is the normal way of doing this. In addition you may want to script out logins, permissions, jobs etc. from the production DB as those are not included in the backup.
😎