Tag Info

New answers tagged

1

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 ...


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: ...


0

I'm sorry, I don't have a corrupt pg_conversion table to help perform any verifications. My answers here must, by necessity, be heavily based on speculation. With the limited information we have, I am guessing that you are attempting to do a full database pg_dump, along the lines of pg_dump --host 127.0.0.1 --port 5432 --username "postgres" ... ...


0

If diskgroup DATA already exists in you ASM instance, the correct syntax is: BACKUP AS COPY DATABASE FORMAT '+DATA'; regards Giova


0

dLight, the issue may have nothing to do with Linked Server. This is most likely a syntax error. Within your BACKUP DATABASE command, you may be using a reserved keyword somewhere, or maybe an extra comma, parentheses or apostrophe. What I'd suggest is : parse the BACKUP DATABASE command in your editor and look for any error messages. Or you can post it ...


0

So in Configuration Manager, you configured the SQL Agent service account, correct? That is the account that will execute SQL Agent jobs, by default. This query will verify your settings: SELECT servicename, service_account FROM sys.dm_server_services go Do you get the error when executing the job via a schedule, when executing manually, or both? If ...


0

I am almost in the same situation to identify the best option for my DR. We are using hyper V replica and planning all database servers to be vitalized. But my biggest problem is we have an integrated SQL Server replication usage for our application load balancing and I am not sure whether it works with hyper V VMs. As per Microsoft it says "If multiple SQL ...


0

You can detect any ddl changes by using trace file. below is script to get changes. SELECT te.name AS eventtype ,t.loginname ,t.spid ,t.starttime ,t.objectname ,t.databasename ,t.hostname ,t.ntusername ,t.ntdomainname ,t.clientprocessid ,t.applicationname FROM sys.fn_trace_gettable ( CONVERT ...


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 ...


0

You can use dbms_metadata to export to generate entire DDL of an Oracle schema, given the post I pointed out earlier in comment: How to generate entire DDL of an Oracle schema (scriptable)? Using the same package, you can generate the tablespaces DDL: select 'select dbms_metadata.get_ddl(''TABLESPACE'',''' || tablespace_name || ''') from dual;' from ...


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, ...


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 ...


0

This error usually means that NTFS cannot add more fragments to the file being written to. Normally, this happens for CHECKDB sparse files but it could happen to any file. It is not sparse file specific. I suspect your NTFS volume is already heavily fragmented. If there are many free space holes NTFS is prone to create many small fragments for new files. I ...


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.


0

This part of your SQL is incorrect DISK = N'\Mylocation\DBRestores\MyBackupFile' it should be for example DISK = N'\Mylocation\DBRestores\MyBackupFile.bak' you are supplying a directory but should be supplying the full spec of the backup file.


0

What you are telling is possible. A pseudo code would look like this : [ Make sure to use database compression and have instant file initialization enabled.] Check if it is first day of the month using select DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0) if it is first day of month, backup the previous month database to archive as ...


0

If you are looking to automate the process of backing up daily and automatically having the database restored onto the dev server from another location in the beginning of the month. I would look into BATCH files with SQL script exec statements. Then set up a windows task to run depending on the task (every 1st day of the month at 3am -- execute the restore ...


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 ...


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.


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 ...


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 ...


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 ...


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} ...


0

Sorry for the above wrong input. I had not followed the question. Here is another set of solution for the above problem: Step 1: create .monetdb file in the home directory as below: cat << EOF > $HOME/.monetdb user=monetdb password=monetdb EOF Step 2: Replace the above content with your monetdb username and password. Step 3:Change the file ...


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 ...


0

Deleting data is easy from the syntax point of view, but that's not all there is. DELETE FROM myTable WHERE someDate < deletionDate might give you a few nasty suprises. Constraints might block you from doing a delete. A textbook example is a foreign key constraint between customer and order tables. Deleting a customer is not allowed as long as there are ...


-1

Here is a good article that explains what the Transaction Log is, and why do you need one!


-1

I'm afraid there is no way how to do that, archivelogs are a must. Best approach is to use approach recomended by the vendor. Datafiles might be inconsistent anytime, Oracle writes changes into blocks even before the transaction is commited. The only place where you can find an information needed to have data consistent is in (archived) redo-logs. Oracle ...


0

Any opinions or insight on what (when) to choose one over the other would be welcome My knowledge is limited when it comes to Hyper V's replication functionality... So, rather than present you with detailed thoughts and opinions on which way might be better, I would steer you towards some solid testing of both options upfront. I imagine you're ...



Top 50 recent answers are included