You can also see that we are restoring this new database on the same logical server where our source database is hosted. I have changed target database name as TestDB_26Aug1109AM and kept remaining details as it is. Fill in the details in the below screen as per your choice and click on the Review + create button. You can change restore point time, target database name, compute, and storage size, etc. You must validate all details highlighted with the dark red arrow and modify them according to your requirement. You can see almost all the details are appearing with prefilled data and all source details are greyed out which cannot be changed. The below screen will appear once you will click on the “ Restore” button of the above image. You can use this tab to initiate the database restore. You can see there is a Restore tab on its overview page in the right-side Now, login to the Azure portal and access the Overview page of Azure SQL database TestDB. I have executed this cmdlet and get the below output which shows “ RestorePointType” is CONTINUOS which means the point in time recovery TestDB along with its resource group name. Pass server name on which TestDB database is hosted, database name Use PowerShellĬmdlet Get-AzSqlDatabaseRestorePoint to display the backup status of database TestDB. First, we will check the status of automatic backup which will be required to restore this Azure SQL database.
Here, I will restore the TestDB database with a different name using the Azure portal. Restore Azure SQL database with a different name
Let’s restore this database with the help of its automatic backups in the next section. To do this, we must restore this database with a different name and copy the table from the newly restored database or only deleted rows to our main database. Now, you have to recover it without impacting other database objects. Somebody has dropped this table or deleted some inserted data from this table. This table if you want to store some data inside this table. We can see table employee has been created in the database “ TestDB“.
0 kommentar(er)
