Database backup and restore - Revision history

Kelamor: Add language bar

2011-12-03T16:20:02Z

Add language bar

JackFuzz: /* Troubles with sqlcmd */

2010-03-31T08:45:35Z

‎Troubles with sqlcmd

Eshme: /* Restore */

2010-02-04T00:29:39Z

‎Restore

Eshme: /* Backup */

2010-02-04T00:29:27Z

‎Backup

Eshme: /* Restoring the Database if it failed after Installation */

2010-02-04T00:28:46Z

‎Restoring the Database if it failed after Installation

Eshme: Seperated the sections from having bugs to haveing none. I had no other idea than to put a disclaimer.

2010-02-03T23:03:23Z

Seperated the sections from having bugs to haveing none. I had no other idea than to put a disclaimer.

Eshme: /* Restoring the Database if it failed after Installation */

2010-02-03T21:25:43Z

‎Restoring the Database if it failed after Installation

Eshme: /* Error Handling */

2010-02-03T21:22:45Z

‎Error Handling

Eshme: /* Error Handling */

2010-02-03T21:15:37Z

‎Error Handling

Eshme: /* Error Handling */

2010-02-03T21:11:01Z

‎Error Handling

@@ Line 169: / Line 169: @@
 . run the backup.bat file and then type Backup to confirm   .... This will backup your entire DA database to the backups folder.  The file was around 783mb for me.
+{{languages}}
 [[Category:Database]]

← Older revision		Revision as of 08:45, 31 March 2010
Line 149:		Line 149:

	Reboot your computer and try it again, it should work.		Reboot your computer and try it again, it should work.
		+
		+	== Quick Backup & Restore ==
		+
		+	Before doing this tutorial I am going to assume you installed the toolset and sql server at the default settings.
		+
		+	Tutorial
		+
		+	1. create a folder called "Backups" in your C Drive.
		+
		+	2. navigate to the folder and make note of the files there.
		+	C:\Program Files (x86)\Dragon Age\tools\DatabaseUtilities\Backup_Restore
		+
		+	3. go to start --> programs --> accessories --> and "right click" on "command prompt" then choose "Run as administrator"
		+
		+	4. A new window will come up and you'll notice in the top left it will say administrator and you should be at the windows\system32 directory
		+
		+	5. change directory to the backup_restore folder above.
		+
		+	6. run the backup.bat file and then type Backup to confirm .... This will backup your entire DA database to the backups folder. The file was around 783mb for me.


	[[Category:Database]]		[[Category:Database]]

@@ Line 123: / Line 123: @@
 <tt>sqlcmd -S .\BWDATOOLSET -E -Q "BACKUP DATABASE bw_dragonage_content TO DISK = 'C:\Backup\bw_dragonage_content.bak'"</tt>
-== Restore ==
+=== Restore ===
 <tt>sqlcmd -S .\BWDATOOLSET -E -Q "RESTORE DATABASE <Database Name> FROM DISK = '<Backup Directory><Backup Filename>' WITH REPLACE"</tt>

@@ Line 109: / Line 109: @@
 Also note that SQL Server is very picky about directory access permissions, and may not be able to write to the directory of your choosing. Check to make sure that your backup file was actually created after doing a backup. A common way of ensuring that SQL Server will be able to write to the backup directory is to create the backup directory directly off of the root of your drive, such as C:\Backups\.
-== Backup ==
+=== Backup ===
 <tt>sqlcmd -S .\BWDATOOLSET -E -Q "BACKUP DATABASE <Database Name> TO DISK = '<Backup Directory><Backup Filename>'"</tt>
@@ Line 122: / Line 122: @@
 <tt>sqlcmd -S .\BWDATOOLSET -E -Q "BACKUP DATABASE bw_dragonage_content TO DISK = 'C:\Backup\bw_dragonage_content.bak'"</tt>
 == Restore ==

@@ Line 5: / Line 5: @@
 If you installed the Toolset, and receive an Error message "Unable to connect to Database", and have never made a Backup, this Solution helps. Although it is a batch file, and requires the users maintenance.
-'''Note:''' Be aware that it will overwrite the old Database if it existed. Doesnt apply if you never used the Toolset before. If you get this message you want to restore, not backup as some think.
+'''Note:''' Be aware that it will overwrite the old Database if it existed. Doesnt apply if you never used the Toolset before.
@@ Line 94: / Line 94: @@
 '''Reinstall:''' If you customized the installation, you may want to reinstall the Toolset and try again. There can be errors if entering something out of the norm.
 == Using the Backup and Restore batch files ==

@@ Line 70: / Line 70: @@
 '''6.''' If an load of Errors occur, see Error Handling below. (The error might be somewhat hidden, but look for the first occurance first.)
-== Error Handling ==
+=== Error Handling ===
 '''Note:''' Be sure to try again with Administator rights. Especially on Vista and Windows 7. When you have ran the batch file above, note the first error which occured. Heres a list:
@@ Line 94: / Line 94: @@
 '''Reinstall:''' If you customized the installation, you may want to reinstall the Toolset and try again. There can be errors if entering something out of the norm.
 == Using the Backup and Restore batch files ==
 A pair of batch files have been included with the toolset install to ease the process of making backups. They can be found at:

← Older revision		Revision as of 21:25, 3 February 2010
Line 5:		Line 5:
	If you installed the Toolset, and receive an Error message "Unable to connect to Database", and have never made a Backup, this Solution helps. Although it is a batch file, and requires the users maintenance.		If you installed the Toolset, and receive an Error message "Unable to connect to Database", and have never made a Backup, this Solution helps. Although it is a batch file, and requires the users maintenance.

−	'''Note:''' Be aware that it will overwrite the old Database if it existed. If you get this message you want to restore, not backup as some think.	+	'''Note:''' Be aware that it will overwrite the old Database if it existed. Doesnt apply if you never used the Toolset before. If you get this message you want to restore, not backup as some think.

@@ Line 73: / Line 73: @@
 '''Note:''' Be sure to try again with Administator rights. Especially on Vista and Windows 7. When you have ran the batch file above, note the first error which occured. Heres a list:
 '''1.''' Among other messages, you get: "MSG 5133, Level 16, State1, Server ****\BWDATOOLSET, Line1" (Error, system cant find that file...)
@@ Line 94: / Line 90: @@
 '''4.''' Amonst other messages, you get: "HResult 0x2, Level16, State 1" Named Pipes Provider: Could not open a connection to SQL Server [2].
 :'''4.1''' Link: http://www.cryer.co.uk/brian/sqlserver/hresult_0x2_npp_error_establishing_connection.htm
 == Using the Backup and Restore batch files ==

@@ Line 75: / Line 75: @@
 '''Search:''' Put the name of the error number into a searchengine. Errors seems to be very common here, and likely can be found.
-'''1.''' Among other messages, you get: MSG 5133, Level 16, State1, Server ****\BWDATOOLSET, Line1 (Error, system cant find that file...)
+'''1.''' Among other messages, you get: "MSG 5133, Level 16, State1, Server ****\BWDATOOLSET, Line1" (Error, system cant find that file...)
 :'''1.1''' The path to TARGET was incorrect and cant bee found. The SQL doesnt create paths on its own. Although the BAT file above will do and tell you anyway. Just in case.
-'''2.''' Among other messages, you get: Msg 3634, Level 16, State 1... "The operating system returned the error (Access denied) while attempting..":
+'''2.''' Among other messages, you get: "Msg 3634, Level 16, State 1..." "The operating system returned the error (Access denied) while attempting..":
 :'''2.1.''' SQL being picky about write access here. Workaround: Change the second line into SET TARGET=C:\DB , and rerun it. You may experiment with this.
-'''3.''' Among other messages, you get: Msg 262, Level 14, State 1, Server ****\BWDATOOLSET, Line 1
+'''3.''' Among other messages, you get: "Msg 262, Level 14, State 1, Server ****\BWDATOOLSET, Line 1"
 :'''3.1''' Vista Problem. (Might apply to Windows 7 too, but it was not released in 2005) Please confirm.
 :'''3.2''' Log in to Windows Vista using your administrative account
@@ Line 89: / Line 89: @@
 :'''3.6''' Source Link: http://blog.techdreams.org/2007/11/create-database-permission-denied-sql.html
-'''4.''' Amonst other messages, you get: HResult 0x2, Level16, State 1 Named Pipes Provider: Could not open a connection to SQL Server [2].
+'''4.''' Amonst other messages, you get: "HResult 0x2, Level16, State 1" Named Pipes Provider: Could not open a connection to SQL Server [2].
 :'''4.1''' Link: http://www.cryer.co.uk/brian/sqlserver/hresult_0x2_npp_error_establishing_connection.htm