You want to set your db to single user mode, do the restore, then set it back to multiuser: ALTER DATABASE YourDB SET SINGLE_USER WITH ROLLBACK AFTER 60 –this will give your current connections 60 seconds to complete –Do Actual Restore RESTORE DATABASE YourDB FROM DISK = ‘D:\BackUp\YourBaackUpFile.bak’ WITH MOVE ‘YourMDFLogicalName’ TO ‘D:\Data\YourMDFFile.mdf’, MOVE ‘YourLDFLogicalName’ … Read more
I have presented git restore (which is still marked as “experimental”) in “How to reset all files from working directory but not from staging area?”, with the recent Git 2.23 (August 2019). It helps separate git checkout into two commands: one for files (git restore), which can cover git reset cases. one for branches (git … Read more
I have just had this issue with SQL Server 2012. It turns out all I had to do was tick the box marked ‘Relocate all files to folder’ on the ‘Files’ section: (Click to see image full size) This of course assumes you have the correct version of SQL Server installed.
You can try to use sed in order to extract only the table you want. Let say the name of your table is mytable and the file mysql.dump is the file containing your huge dump: $ sed -n -e ‘/CREATE TABLE.*`mytable`/,/Table structure for table/p’ mysql.dump > mytable.dump This will copy in the file mytable.dump what … Read more
You can create a new db then use the “Restore Wizard” enabling the Overwrite option or: View the contents of the backup file: RESTORE FILELISTONLY FROM DISK=’c:\your.bak’ note the logical names of the .mdf & .ldf from the results, then: RESTORE DATABASE MyTempCopy FROM DISK=’c:\your.bak’ WITH MOVE ‘LogicalNameForTheMDF’ TO ‘c:\MyTempCopy.mdf’, MOVE ‘LogicalNameForTheLDF’ TO ‘c:\MyTempCopy_log.ldf’ This … Read more
There are two tools to look at, depending on how you created the dump file. Your first source of reference should be the man page pg_dump as that is what creates the dump itself. It says: Dumps can be output in script or archive file formats. Script dumps are plain-text files containing the SQL commands … Read more
Dump and restore a single table from .sql Dump mysqldump db_name table_name > table_name.sql Dumping from a remote database mysqldump -u <db_username> -h <db_host> -p db_name table_name > table_name.sql For further reference: http://www.abbeyworkshop.com/howto/lamp/MySQL_Export_Backup/index.html Restore mysql -u <user_name> -p db_name mysql> source <full_path>/table_name.sql or in one line mysql -u username -p db_name < /path/to/table_name.sql Dump and … Read more
I had this situation restoring a database to an SQL Server 2005 Standard Edition instance using Symantec Backup Exec 11d. After the restore job completed the database remained in a “Restoring” state. I had no disk space issues– the database simply didn’t come out of the “Restoring” state. I ran the following query against the … Read more