keep a note of these options ALTER DATABASE mydb SET ENABLE_BROKER ALTER DATABASE mydb SET DISABLE_BROKER ALTER DATABASE mydb SET NEW_BROKER if youre getting something like this is already an enabled Service Broker with the same ID, go for the NEW_BROKER
I got a .dump file from my server (Heroku). As Klaus said, pg_restore is the only way I could restore it in my local. What I wrote in my terminal was: pg_restore -c -d [database_name] [dumpfile_name].dump There are a lot of options you can see in Klaus link of pg_restore 🙂
You didn’t mention how your backup was made, so the generic answer is: Usually with the psql tool. Depending on what pg_dump was instructed to dump, the SQL file can have different sets of SQL commands. For example, if you instruct pg_dump to dump a database using –clean and –schema-only, you can’t expect to be … Read more
I had the same issue. I simply checked the Checkbox BEFORE choosing the source to restore from. After choosing the source the CB was grey but checked and the restore worked fine.
Yes, it is possible. The steps are: First Put the .mdf and .ldf file in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ folder Then go to sql software , Right-click “Databases” and click the “Attach” option to open the Attach Databases dialog box Click the “Add” button to open and Locate Database Files From C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\folder … Read more
The problem with options 1-3 are that media files (anything uploaded through FileField) are not included in the backup. It is possible to separately backup the directory containing the media files. However, because Django doesn’t remove files when they are no longer referenced by a FileField, you will inevitably end up with files in the … Read more
There is a step by step explanation (with pictures) available @ Restore DataBase Click Start, select All Programs, click Microsoft SQL Server 2008 and select SQL Server Management Studio. This will bring up the Connect to Server dialog box. Ensure that the Server name YourServerName and that Authentication is set to Windows Authentication. Click Connect. … Read more
It seems like pg_restore tries to restore some extra data which you don’t own. Try to add -n public option to your pg_restore command line. It will tell pg_restore restore only contents of public schema. Your command line should looks like pg_restore -U username -c -n public -d database_name
After revisiting my question, I was able to get it to work after looking at how ConnectBot does it. Thanks Kenny and Jeffrey! It’s actually as easy as adding: FileBackupHelper hosts = new FileBackupHelper(this, “../databases/” + HostDatabase.DB_NAME); addHelper(HostDatabase.DB_NAME, hosts); to your BackupAgentHelper. The point I was missing was the fact that you’d have to use … Read more
Could be because of restoring SQL Server 2012 version backup file into SQL Server 2008 R2 or even less.