Yes. Generally, to restore compressed backup files you can do the following: gunzip < alldb.sql.gz | mysql -u [uname] -p[pass] [dbname] Please consult How to Back Up and Restore a MySQL Database Note that the –all-databases option is applicable to backup only. The backup file itself will contain all the relevant CREATE DATABASE quux; commands … Read more
A restore can only happen if the database does not have any connections to it (besides yours). The easy way on a MS SQL Server to kick all users off is: ALTER DATABASE [MyDB] SET Single_User WITH Rollback Immediate GO Now, you can perform your restore with impunity. Make sure you set it back to … Read more
Here’s the fully automated restore T-SQL stored proc. Accepts three(3) parameters. Target Database Source Database Fully Qualified backup file name location (\\yourserver\yourshare\backupfile.bak or simply c:\backup.bak) CREATE PROC [dbo].[restoreDB] @p_strDBNameTo SYSNAME, @p_strDBNameFrom SYSNAME, @p_strFQNRestoreFileName VARCHAR(255) AS DECLARE @v_strDBFilename VARCHAR(100), @v_strDBLogFilename VARCHAR(100), @v_strDBDataFile VARCHAR(100), @v_strDBLogFile VARCHAR(100), @v_strExecSQL NVARCHAR(1000), @v_strExecSQL1 NVARCHAR(1000), @v_strMoveSQL NVARCHAR(4000), @v_strREPLACE NVARCHAR(50), @v_strTEMP NVARCHAR(1000), @v_strListSQL … Read more
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
For regular backups I’d go for option 1, using PostgreSQL’s own native tool, as it is probably the most efficient. I would argue that option 2 is primarily concerned with creating the tables and loading initial data so is not suitable for backups. Option 3 can be used for backups and would be particularly useful … 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