Tag Info

Hot answers tagged

4

I would suggest to use Restore Gene : Automating SQL Server Database Restores - written by Paul Brewer The Restore Gene stored procedure generates the required restore scripts, including the DBCC CHECKDB command, if required. It is a useful tool, by itself; in disaster recovery situations, it can construct a restore script, in seconds. It optionally ...


2

CREATE VIEW or CREATE TABLE... AS SELECT have to infer the column types for the relation to create. Sometimes the context is not sufficient to guess a datatype, for example when it's just a string literal. In this case it's created as unknown. Example : test=> CREATE VIEW testview AS SELECT 'bla' AS foobar; WARNING: column "foobar" has type "unknown" ...


2

First thing i would like to highlight is you should have the system backups in addition to user databases handy when you said you need to migrate from SQL2k5 to SQL2k8R2. You can copy all the latest backups from the current server onto the Windows2K8 box you mentioned. Once copied, the first thing you should be looking is restoring the system database ...


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


1

Finally after two days I get those error, because of lack of memory you need to add more memory if you work with big collection.


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

For first you can configure log shipping to a new box. So at any given time you can switch to new box fast, but it will be impossible to revert to an old box if something happened after you have started to work with databases on a new box.


1

That's the error you get when you restore the master database from a server with AlwaysOn Availability Groups configured, or try to restore additional user databases onto a server that had the master database from an AG replica restored. Don't restore the master database from an AG replica onto a different SQL Server as the master database. If you ...


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

With the default settings, when rows (or entire tables) are deleted, SQLite does not remove empty pages from the database file. (This setting can be changed with PRAGMA auto_vacuum.) In most cases, keeping empty pages in the database file is good idea because they will be reused by new rows that are inserted later, and adjusting the database file to remove ...


1

I am Powershell dude (sounds like I am attending a Powershell Anonymous meeting!!) so this is the script I would use although I would use the objects returned to write to a database for a report or write to Excel or create an HTML email for my manager or whatever was required. Remember the $Servers should hold SERVERNAME\InstanceName,PORTNumber if any of ...



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