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

Question

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

BarryM 16

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

Navtej Singh Saini 4,226 Reputation points Microsoft Employee Moderator

2021-03-18T20:04:02.463+00:00

Thank you @tibor_karaszi@hotmail.com for helping.
@BarryM - Please let us know if you need any further help with this.

1 answer

Your answer

Navtej Singh Saini 4,226 Reputation points Microsoft Employee Moderator

2021-03-18T20:04:02.463+00:00

Thank you @tibor_karaszi@hotmail.com for helping.
@BarryM - Please let us know if you need any further help with this.

Answer 1

tibor_karaszi@hotmail.com 4,316

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...

BarryM 16 Reputation points

2021-03-16T20:07:58.897+00:00

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 thanks
tibor_karaszi@hotmail.com 4,316 Reputation points

2021-03-17T09:38:22.54+00:00

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.

Share via

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

1 answer

Your answer