Tag Info

Hot answers tagged

6

Your all points are covered in backup myths - by Paul Randal 30-01) backup operations cause blocking No. Backup operations do not take locks on user objects. Backups do cause a really heavy read load on the I/O subsystem so it might look like the workload is being blocked, but it isn't really. It's just being slowed down. There's a special case where a ...


5

The article written by Paul regarding backup internals is excellent one and you must read it. Adding to what others have said and emphasizing on specific part of your question Also I heard that backing up is single threaded meaning it uses only one core, assuming you backup to a single file. Also assuming you have a multicore machine, for example 16 ...


4

You must be running in a Security Group firewall problem. Go to your RDS Dashboard, select Instances and open the instance you want to connect to. Look for a line like this : Security Groups rds-launch-wizard (sg-3e9axxx) ( active ). You should be able to click on rds-launch-wizard (sg-3e9axxx) which leads you to the EC2 Dashboard in the Security Groups ...


4

Basically, SQL Server does a dirty copy of all pages on disk. Those pages are likely inconsistent if there is concurrent activity or if there previously way non-checkpointed activity. Then, SQL Server also copies the necessary part of the transaction log that is needed to bring the out of date pages to the latest version and make everything consistent on ...


4

Skipping the backup altogether is not a good idea in my opinion. You should probably keep on taking differential backups instead. They will probably be very small and not a concern at all. Detecting the percentage of data that changed since last FULL backup can be done using this function by Paul Randal.


3

You can use sqlmigration - Start-SqlServerMigration.ps1 This script provides the ability to migrate databases using detach/copy/attach or backup/restore. SQL Server logins, including passwords, SID and database/server roles can also be migrated. In addition, job server objects can be migrated and server configuration settings can be exported or ...


3

I can't tell you about the cloud disk but when you backup to a network share you can: Create a network share and assign permissions (I go with full control) to the SQL Server database engine service account (it has to be a domain account) Backup database to this share like that: BACKUP DATABASE AdventureWorks TO DISK = ...


3

I would suggest automating generation of the restore script. There are a few versions of this out there but Paul Brewer has a T-SQL and PowerShell version available. I have seen some setups as well that just include generating a restore script when the backup is accomplished. Which, just a note that a new open source backup solution was released by Sean ...


3

In order to restore a contained database into a different instance of sql server, in this case my local server, the "Enable Contained Databases" property must be set to True. You can do this from management studio: Right-Click on the server instance, select Properties Select Advanced page, set under Containment the property value to True Proceed to ...


2

Have you tried doing what the error is describing? USE master GO sp_configure 'show advanced options', 1 GO RECONFIGURE GO sp_configure 'CONTAINED DATABASE AUTHENTICATION', 1 GO RECONFIGURE GO sp_configure 'show advanced options', 0 GO RECONFIGURE GO


2

Add columns: msdb.dbo.backupset.software_vendor_id, msdb.dbo.backupset.user_name to your query. If your software vendor id = 4608 then its sql native, anything else is a third party software. The user name should give you some clues as to what is occurring. Also check SQL Agent for jobs executing at around that time.


2

The above issue which you are facing is commonly known as the case for Orphan users: What commonly happens with SQL authenticated logins and database users on a restore is that the SIDS will be out of sync, thus breaking the relationship. This relationship must be repaired before you can connect to the database using that login, because in the eyes of SQL ...


2

It is not possible, because you cannot create a backup of an offline database. From MSDN: Without the NO_TRUNCATE option, the database must be in the ONLINE state. If the database is in the SUSPENDED state, you might be able to create a backup by specifying NO_TRUNCATE. But if the database is in the OFFLINE or EMERGENCY state, BACKUP is not ...


2

I write Minion Backup and this kind of thing would be very easy to do. We allow you to run Pre and Post code before each DB, so for your SharePoint DB, you can just put it into single-user mode and change it back when it's done. However, we can't guarantee that you'll be the one to get that connection. But you can download Minion Backup here and give it a ...


2

In order to take the backup of MySQL Server Objects i.e routines / triggers / events you can do like below mysqldump -h$MySQLHost -u$YourUser -p$YourPassword --no-data --no-create-info --routines --triggers --events $Database > MySQLStoredProcedures.sql The above will backup only the database objects , no data , no create table etc.


1

Stored procedures are stored in database mysql. Innobackupex copies it by default. Make sure database mysql is restored with other databases.


1

SQL does not allow to backup a database when in offline mode. You can also create maintenance plans in order to automate the job. So the first step of you job can be setting the offline databases to online mode and then the maintenance plan will do is work and then the third step will be to set your databases back to online.


1

Two things. First if you are going to do that then make your script this: ALTER DATABASE [TEST_1] SET SINGLE_USER WITH ROLLBACK IMMEDIATE GO USE [TEST_1] GO BACKUP DATABASE [TEST_1] TO DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\test\test_1.bak' WITH NOINIT, STATS = 10 GO ALTER DATABASE [TEST_1] SET MULTI_USER WITH ROLLBACK ...


1

A system assertion check has failed. Check the SQL Server error log for details. Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB This error can be caused by transient, timing-related errors, or by in-memory or on-disk data corruption. This message also says ...


1

I would prefer not to use this backup solution but I have no choice but to cope with it. You are thinking absolutely correct. Please note that VMware backups take backup using snapshot mechanism its not like backup you take using TSQL Command. Its not a good idea to rely on VM backups I strongly suggest you to start takign TSQL backup specially if ...


1

When it comes to an empty binary log, it is version specific: 120 in MySQL 5.6 107 in MySQL 5.5 106 in MySQL 5.1 98 in MySQL 4.1/5.0 I have discussed this many times in the DBA StackExchange Nov 19, 2014 : Question on having a MySQL 5.1 replicate from a MySQL 5.6 DB Jun 26, 2013 : Is it possible to convert mysql binlog from statement format to row ...


1

From Thomas LaRock at http://logicalread.solarwinds.com/sql-server-dbcc-log-command-tl01/#.VXbj_DYpDVk "The fn_dblog() function (formerly known as the DBCC command) is one of several undocumented functions for SQL Server; it allows you to view the transaction log records in the active part of the transaction log file for the current database." The fact ...



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