|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 936
|
So I got an error during a remote backup and it was something to do with insufficient memory. I was curious if I need to have enough memory to hold the entire database or if it simply scripts it a certain amount of lines at a time?
Any help or advice would be appreciated. It's running on a cloud so I can simply increase the memory if needed but I'd like to be sure thats the issue.
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 936
|
Database scripting failed: An error occured while getting table data. >> System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
at System.String.GetStringForStringBuilder(String value, Int32 startIndex, Int32 length, Int32 capacity)
at System.Text.StringBuilder.GetNewString(String currentString, Int32 requiredLength)
at System.Text.StringBuilder.Append(String value)
at e.a.a(Byte[] A_0)
at d.l.c(String A_0, Stream A_1)
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/12/2009
Posts: 271
|
Probably you try to backup a very large amount of data. We didn't test this feature on very big data amount that's why it's still in beta. I suggest you to find another backup method in your case.
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 936
|
I have this error also. The backup works fine on a larger database and the second database is a very small database. If fails on the small one. So I doubt the issue is to do with size.
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 936
|
When writing to a text file as a script, if the INSERT clauses are too much it will ran out of memory even if you use Microsoft SQL Database Publishing Wizard. In this case, you have no option other than the classic way of backup in SQL Server Management Studio. Your database may be small in size but if it contains a table with only one text column but in 2000000 rows, then you will face this problem.
www.netprohost.com
|
|
|
|
|
