azure - Database export throwing SystemOutOfMemory exception -
i trying export sql azure database azure storage using azure portal.
for reason getting following error every time try export database:
error encountered during service operation. not export schema , data database. 1 or more errors occurred. 1 or more errors occurred. 1 or more errors occurred. 1 or more errors occurred. 1 or more errors occurred. exception of type 'system.outofmemoryexception' thrown.
previous backups of database have resulted in bacpac file of 112 mb. database 2.62 gb in size.
other smaller databases have backed today, it's larger database continually fails error.
any ideas can working?
the problem has been resolved.
the portal has been our normal route performing backups, it's performed numerous backups without hiccups. however, failure offered little more outofmemoryexception, reverted ssms backup option msdn article (something should have done prior raising question), which, although still failed, highlighted problem data related , not portal.
the actual issue relates single xml column in single table - ssms highlighted table failed. thankfully, data transient, should regularly deleted , not need backed up.
we have since performed required maintenance , result been able full backup.
Comments
Post a Comment