Tag Info

Hot answers tagged

4

I'm not sure I would advocate it as a good solution, neither performance wise nor as a best practice, but there actually is a possibility. In short, the steps would be Make a backup on a swap file on the server Create a temporary table with a varbinary field Insert the backup into the table Fetch column data using ADO.NET Save the stream in a file The ...


3

In the simplest case, when you restore a database, you tell RMAN to recover it to the most recent point in time by applying all the redo (archived and online) that is available. That will re-apply any statements that were executed during normal database operations including things like dropping tables and deleting data. If you want to restore a database to ...


3

I believe its just a message and not an error unless and until the task is getting impacted when this message is logged in the error log: We also encountered the same for one of our production server, where windows admin team enabled the SQL Server backup through VSS (Volume Shadow Copy Services). And when this process runs it freezes I/O temporarily to ...


3

A full backup will contain all used pages in both files (you can convince yourself of this by restoring a full backup: the new files end up the same sizes with the same amount of content, which means the backup must have contained the information required to achieve that). Both files, especially the transaction log, will contain block that are allocated from ...


2

You would dump each table using the --where option. I wrote a rather gnarly post about 4 years ago : Is it possible to mysqldump a subset of a database required to reproduce a query? In your case, you can do the following: Suppose the database is called schooldb Dump by SchoolID MYSQL_USER=root MYSQL_PASS=rootpassword MYSQL_CONN="-u${MYSQL_USER} ...


2

While you can't control if the backup happens, could you ask the third party to change how the backup is taken? Using the COPY_ONLY option stops backups from interrupting other backup sequences, so if they add that to their process it will stop interfering with your's. See https://msdn.microsoft.com/en-gb/library/ms191495(v=sql.120).aspx for more info. That ...


2

With that in mind, I've thought about creating a remote client that would run on my NAS server and that would connect to my different SQL Server instances and issue the job of backing up those databases on a regular basis. You can use SQLCMD - command line utility to backup your databases on multiple servers. Put SQLCMD in a .bat file and schedule it ...


2

In my biased opinion (I'm author of TwinDB) the best way to take backups from MySQL is to use TwinDB. Not only it will save from blunders like rsyncing database files (which with 100% guarantee leads to corrupted tablespace) but also lets you take incremental copies correctly.


2

Original Answer (leaving for people that might hit this because of the simple explanation): The clusterAdmin role only applies when you authenticate against the admin database, so unless you specify the --authenticationDatabase option to be admin when you are running mongodump/mongorestore I suspect you are getting a lesser privilege when authing against ...


2

As an answer to your first question, both tools (by default) will just walk the _id index to fetch the data and then write it out to disk. So, yes, both tools will similarly impact your working set which is why I would generally recommend running them against a secondary (preferably a hidden secondary if possible). I'll echo Stennie in the comments here ...


2

(sorry, dunno) --query will select or exclude entire documents, not fields. It would be a good idea though : --query '{datetime:{$gt:ISODate("2014-01-01T00:00:00.000Z")}},{_id:0,name:1,address:1,interests:1}'* ) Mongodump uses bson file structure and preserves the data types. Mongoexport will lose data type of the values. Such as ...


1

Perhaps you should dump the users and load the users into the VM Here is my post : Export all MySQL users After running the code in it and saving it to a file called MyDatabaseUSers.sql, you log into mysql on the VM and run this: mysql> source MyDatabaseUSers.sql This will create all the users with the same grants and passwords. Don't worry: ...


1

Judging by the answer you gave in response to @Ozzie, I'm not sure you can do what you want. You can export the metadata of an 11gR2 database using expdp (Data Pump) and the METADATA_ONLY flag. See http://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_export.htm This will export the structure of your data. This won't include redologs, controlfiles, ...


1

Check if the SQL Server user account is able to read from "\Mylocation\DBRestores\", the security permissions from file share and file system. To really test that it works, copy the backup to local server and run it from there.


1

For a relatively small database, the mysqldump utility can be an effective way to backup the database. We use a shell script, execution scheduled thru cron We run separate mysqldump for each database. We omit the "create database" and "drop table" statements. We also include options to get a "consistent" backup of the InnoDB tables. There's some ...


1

Does .bak file also contain backup of ldf file? No it does not contains backup of ldf file. It might contain some information not the complete backup. A full or differential backup contains enough log to be able to recover the database to a transactionally-consistent view of the database at the time the data-reading portion of the backup finished (or ...


1

You probably have checkpoint_timeout set very high on the production system, and archive switches are being driven by checkpoint_segments, probably in conjunction with a low setting of archive_timeout. But, checkpoint_segments has no effect during recovery. Restartpoints during recovery are driven exclusively by checkpoint_timeout. Since recovery can ...



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