ALL: How to backup/restore a database in SQL Server Management Studio
Backup a database
1.
Open SQL Server Management Tools, navigate to the database which will be backed up, right click on it and select
Tasks -> Back up:
2. O
n General tab, remove the previously used backup location by pressing 1 Remove and then 2 Add
3.
Select the backup destination by pressing
3 …
4.
Select the path of the backup using the navigator
4
(usually it’s D:\Backup) and fill in the backup name manually
5
(usually it’s
DATABASENAME_DATEOFBACKUP_CREATORINITIALS.bak
)
5.
Press
OK
button until you reach the initial screen and finally press
6 OK
to start the backup process
6.
Database backup successful:
Restore a database
1.
Right-click on database to be restored, navigate to
Tasks->Restore->Database
2.
Select
1 Device
and press
2…
to browse
3.
Press
3 Add
4.
Select the backup you wish to restore using the navigator
4
and press
5 OK
5.
Press OK until you reach the General tab, check that the database name and path are correct, DO NOT PRESS OK
6.
Go to Files tab and make sure that the Restore As names correspond to PrxData folder used on the machine (change the destination if needed by pressing
…
)
7.
Go to Options tab and select
Overwrite the existing database (WITH REPLACE)
8.
Press OK and database will be restored
ATTENTION: DO NOT RESTORE a database unless instructed to do so by SUPPORT!
Related Articles
ALL: Tracing Orpak applications on SQL 2008, using SQL Profiler
Tracing Orpak applications on SQL 2008 using SQL Profiler SQL Server Profiler is a rich interface to create and manage traces and analyze and replay trace results. The events are saved in a trace file that can later be analyzed or used to replay a ...ALL: Adding recipients for Replication email alerts
Go to the Database Server, navigate to Jobs, select Replication_EmailAlert Click on Properties -> Steps -> Edit: In the command window, add or remove emails by maintaining the correct punctuation: each email is separated by semicolon ; all the ...How to make a trace file on Passport Alpha applications.
1. Open SQL Profiler application 2. Connect to SQL server on the machine 3. Events selection tab and press Column filters: 4. Here you have 3 columns that needs to be checked: a. Application name b. Binary Data c. ClientProcessID After you check the ...How to change FHO services default port
FHO services default port: If you want to change them, you need to do the two updates below in the database. And then restart the specific service: For example if you want to change the default port of Administration service: update device_params set ...How to import a xlsx file for price update
Excel file fields: Station column - Text StationList column - Text ItemCode column - Text ItemName column - Text Price column - Number PriceNumber column - Text WaitForEOD column - Text ActivateTime column - Custom: d/m/yyyy hh:mm VatablePrice column ...