Microsoft SQL Server Management Studio - Copy Database

Hi, I am using MSSQL as a database for an RPA project.

I need to copy the database to a separate one for testing purposes.

I have been searching the web on how to do this, however I can’t find the required options to follow step by step.

Either the instructions say to Copy the database

or to backup database
I dont see either of those options

How do I proceed with duplicating the database?

Are you right-clicking correctly on the data base?
Which MS SQL version are you using?
Please check.

Karthik Byggari

Hi, I figured it out… thanks