Difference between revisions of "User:Allan Smith/sandbox/SQL Server Backup and Restore"
Allan Smith (Talk | contribs) (Created page with 'Sandbox page for taking notes for later publication on the subject There are a wealth of pages on the web about this proces, but want to do one that works very specifically for D...') |
Allan Smith (Talk | contribs) (still playing) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
Sandbox page for taking notes for later publication on the subject | Sandbox page for taking notes for later publication on the subject | ||
| − | There are a wealth of pages on the web about this | + | There are a wealth of pages on the web about this process, but this one is put together very specifically for Dragon Age toolset users. Step by step with pictures etc. |
| − | ==Installing SQL | + | {{Dashedborder|Note: Instructions generally refer to default installation locations. You may need to adjust them to match your particular installation.}} |
| + | |||
| + | |||
| + | ==Installing SQL== | ||
| + | |||
| + | ==Installing SQL Server Management Studio Express== | ||
| + | You will need to have SQL Server Management Studio Express installed to do Backup and Restore your database using the following instructions. | ||
| + | |||
| + | It can be downloaded from: | ||
| + | |||
| + | Accept all the default settings from the installer. | ||
==Backing up your database== | ==Backing up your database== | ||
| + | Instructions Straight from the horses' mouth. http://msdn.microsoft.com/en-us/library/ms187510%28SQL.90%29.aspx | ||
| + | |||
| + | Here is a somewhat simpler set of instructions, complete with pictures, and the Dragon Age toolset default database. | ||
| + | Save your work in the toolset, the close toolset. (not absolutely necessary, but why tempt fate?) | ||
| + | Open SQL Server Management Studio Express | ||
| + | Connect to the your server. Should come up by default as something like COMPUTERNAME\BWDATOOLSET | ||
| + | In the left hand pane, open up the databases folder. You should see "bw_dragonage_content". Right click to bring up the context menu and select Tasks>>Backup | ||
==Restoring up your database== | ==Restoring up your database== | ||
| + | Instructions Straight from the horses' mouth. http://msdn.microsoft.com/en-us/library/ms177429.aspx | ||
Latest revision as of 00:35, 24 November 2009
Sandbox page for taking notes for later publication on the subject There are a wealth of pages on the web about this process, but this one is put together very specifically for Dragon Age toolset users. Step by step with pictures etc.
Contents
Installing SQL
Installing SQL Server Management Studio Express
You will need to have SQL Server Management Studio Express installed to do Backup and Restore your database using the following instructions.
It can be downloaded from:
Accept all the default settings from the installer.
Backing up your database
Instructions Straight from the horses' mouth. http://msdn.microsoft.com/en-us/library/ms187510%28SQL.90%29.aspx
Here is a somewhat simpler set of instructions, complete with pictures, and the Dragon Age toolset default database. Save your work in the toolset, the close toolset. (not absolutely necessary, but why tempt fate?) Open SQL Server Management Studio Express Connect to the your server. Should come up by default as something like COMPUTERNAME\BWDATOOLSET In the left hand pane, open up the databases folder. You should see "bw_dragonage_content". Right click to bring up the context menu and select Tasks>>Backup
Restoring up your database
Instructions Straight from the horses' mouth. http://msdn.microsoft.com/en-us/library/ms177429.aspx
