Hot answers tagged

3

First of all, you can use a pipe mongodump -h sourceHost -d yourDatabase … | mongorestore -h targetHost -d yourDatabase … This reduces the time, as each document read will more or less instantly be restored on targetHost. However, this has the disadvantage that you might run into problems if the procedure is aborted for some reason, for example of a ...


3

First off... I think it is best to come clean to your manager on such issues. The business will notice the missing data and he will not appreciate being blindsided and not having all the facts at hand. In that event, things will be even worse for you. If you have no formal background in DBAing, you have no business doing DBA tasks and/or the real ...


3

Come clean ASAP. The sooner you do this the better. If I'm reading the timeline correctly, when you restored the FULL backup over your production database you broke the backup chain. This means you wont be able to get the data for 06:30PM to 10:00PM into your current database that holds data for 01AM to 06:30PM + new data since the RESTORE. I would ...


2

No ! But, you can : 1 script our your database schema and use BCP out and bcp in method or 2 restore the database as a copy on EE or Dev edition, remove all enterprise features and backup the database and restore it on standard edition.


2

You have two alternatives: 1. Load the file into a new database and do a query for the particular date that you want. or 2. Hand edit the dump file and load that (also in a new database). The second alternative has several disadvantages: hand editing is unreliable and error prone. you may break integrity constraints - not easy to see in a load of ...


1

As already suggested, you cannot achieve this using backup/restore. You can also not achieve it using log shipping. I would look at using transactional replication perhaps from views, which would define the 60 to 90 day window. Be aware (or make your stakeholders aware) that replication is not free and comes with its own (usually small) performance ...



Only top voted, non community-wiki answers of a minimum length are eligible