question

BarryM-2336 avatar image
0 Votes"
BarryM-2336 asked ·

I tried to backup my database locally form azure database, why is it that my data tripled?

My data trippled after i tried to backup my database locally. I fowlloed the instructiions from here https://sqlbackupandftp.com/blog/how-to-backup-azure-sql-database-to-local-machine Please advise on how i can restore my database to original. thank you in advance

azure-sql-database
· 1
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you @TiborKaraszi for helping.
@BarryM-2336 - Please let us know if you need any further help with this.

0 Votes 0 ·

1 Answer

TiborKaraszi avatar image
0 Votes"
TiborKaraszi answered ·

You need to give us a lot more details if you want any type of qualified guesses.

Exactly which of the methods on that web-site did you use?

None of those methods will give you a binary copy of the database. All of them uses some type of export/import. This means that it is expected that the size isn't the same. In order to say more we need to know things such as if it it the data or transaction log that is larger? If you have free space? Where this free space is? Are your tables/indexes larger? Or do you have unused pages/extents in the database file? Or perhaps you have compression in your SQL Database and the export method you use didn't carry the compression setting over.

So many possibilities...

· 2 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank your for your reply Sir TiborKaraszi,

But what i did was I used the method "Using SQL Server Import and Export Wizard" and was able to backup locally but i am not sure if the data in my database after backup has been carried on as that is what i am ought to do. But after that my client complained that thier data has trippled. What could be the issue? on that case, So another thing i did was to restore my database which is 2 days ago, but after the process using Azure's database restore method it created another copy of my database dated two days ago and i find it useless becuase it did not restore my database instead created another copy of my database.

How can i restore my database dated two days ago? so put things back. I have attahced a screenshot of the database and would like to replace the original with the backup.
PLease help thanks78441-isue.png


0 Votes 0 ·
isue.png (97.9 KiB)

I don't know what you mean exactly by "trippled" so I can't answer that.

In Azure SQL Database, you can't overwrite an existing database when you restore. You can restore to a new name, and then rename to the "production" database name. Of course you first have to rename the "production" database to something else.

0 Votes 0 ·