amazon rds - Unable to restore SQL Server bak file from S3, says file too large -

-

i'm trying run restore query bak file stored in s3 bucket rds sql server web edition, , kept getting error:

[2017-09-13 20:30:22.227] aborted task because of task failure or concurrent restore_db request. [2017-09-13 20:30:22.287] there not enough space on disk perform restore database operaton.

the bak file 77 gb , db has 2tb, how come still not enough?

this query aws docs:

exec msdb.dbo.rds_restore_database          @restore_db_name='database_name',          @s3_arn_to_restore_from='arn:aws:s3:::bucket_name/file_name_and_extension';

source: http://docs.aws.amazon.com/amazonrds/latest/userguide/sqlserver.procedural.importing.html#sqlserver.procedural.importing.native.using

there not enough space on disk perform restore database operaton.

...

the bak file 77 gb , db has 2tb, how come still not enough?

you need 2tb of space able restore backup.

the fact restore operation reconstruct original database 2tb.

backup backing data, not empty space. if backup 77gb , not compressed means your original database has 77gb of data (or less, because backup contains amout of log well).

any database consists of data file(s) , log file(s), , if db 2tb 77gb of data, means has enormous log file. think it's in full recovery model , not take regular log backups (or did not take log backup @ all!!)

so should take @ original db, change recovery model simple if don't need point in time recovery , take no log backups, or, if need full recovery model, should backup log more frequently.

taking regular log backups or changing recovery model simple permit shrink log reasonable size, moment not need 2gb of space restore anymore


Comments

Post a Comment

Popular posts from this blog

ios - MKAnnotationView layer is not of expected type: MKLayer -

-
Image
so code works fine logger riddled message. there way rid of or suppress it? postannotation.swift class postannotation: mkpointannotation { //mark: properties let post: post //mark: initialization init(post: post) { self.post = post super.init() self.coordinate = cllocationcoordinate2d(latitude: post.latitude, longitude: post.longitude) self.title = post.title self.subtitle = post.timestring() } } adding annotation let annotation = postannotation(post: post) self.map.addannotation(annotation) func mapview func mapview(_ mapview: mkmapview, viewfor annotation: mkannotation) -> mkannotationview? { if annotation mkuserlocation { return nil } var annotationview = mapview.dequeuereusableannotationview(withidentifier: "pin") as? mkpinannotationview if annotationview == nil { annotationview = mkpinannotationview(annotation: annotation, reuseidentifier: "pin")
Read more

ZeroMQ on Windows, with Qt Creator -

-
i have installed zmq link given below on windows 7. http://zeromq.org/distro:microsoft-windows 1) have c++ project in qt-creator , i'm using zmq c++ binding (zhelpers.hpp etc). 2) have added .lib installed zmq folder qtcreator 3) while compiling, compiler looks _imp__zmq_verion, in .dll files present in .lib have __imp_zmq_version. 4) causing undefined reference zmq_version. anyone else faced problem , has solution ?
Read more

unity3d - Unity SceneManager.LoadScene quits application -

-
i have 2 different scenes 1 named 'main' , other 'game' both added scenes in load. when use scenemanager.loadscene("game"); works no problem when tried return main scene code if (input.getkeydown (keycode.escape)) { scenemanager.loadscene("main"); } strangely game quits. thanks. sorry interruption. somewhere on other script found code. if (input.getkeydown (keycode.escape)) { application.quit (); } that's bad, know...
Read more