| |
SQL Server Backup
|
| |
|
| |
|
| |
How do I backup my MS SQL Server? |
| |
Click backing
up your MS SQL Server for details.
|
| |
|
| |
 |
| |
|
| |
Under what name and extension are the MS SQL Server backup files stored on IBackup? |
| |
The backed up files are stored in your IBackup account with the extension '.dmp', file name enclosed within square brackets.
Format of
the file name is as shown here:
[<name of database>].dmp
For
ex: [model].dmp, [pubs].dmp, [order list].dmp. |
| |
|
| |
|
| |
Can I backup databases
from multiple instances of MS SQL Server? |
| |
Yes. You can backup databases from multiple instances of the MS SQL Server running on your local computer.
However, you may be unable to backup databases from multiple instances of MS SQL Server hosted at multiple locations on your network. |
| |
|
| |
|
| |
I am unable to view the databases in the instance of MS SQL Server that I am logged into. Why? |
| |
This is due to lack of proper access permissions/privileges for the username that you are logged in with. Thus, you maybe unable to view all the databases under the instance. Contact your database administrator to obtain the privileges to access the databases. |
| |
|
| |
|
| |
Can I backup the MS SQL Server in the 'Mirror Path' mode? |
| |
No. Even if you opt to backup using 'Mirror Path', they will take place in the 'Relative Path'. |
| |
|
| |
|
| |
Can I backup MS SQL Server 'tempdb' database? |
| |
No. You cannot backup your MS SQL Server 'tempdb' database. |
| |
|
| |
|
| |
How do I restore my database backup file (*.dmp) to my MS SQL Server? |
| |
IBackup for Windows provides two methods to restore your database backup file (*.dmp) to the MS SQL Server.
Click restoring
your MS SQL Server for details.
|
| |
|
| |
|
| |
|
| |
Can IBackup for Windows backup the entire
SQL Server database? |
| |
IBackup for Windows with SQL Server Backup has the ability to backup the entire database that has been selected for backup along with the corresponding database log file to your online IBackup account (with '[<database name>].dmp'). i.e. '[<database name>].dmp' backup file containing the entire structure and component of selected database and the corresponding database log file.
You can also backup multiple databases wherein each database has its own corresponding '[<database name>].dmp' file. |
| |
|
| |
|
| |
Can I restore my database file to a different MS SQL Server database? |
| |
Yes. You can restore your database backup file (.dmp) to a different database by providing a new database name. Further, it is possible to change the data and transaction log file location as desired. |
| |
|
| |
|
| |
|
| |
Under what circumstance should I restore the MS SQL Server 'master' database? |
| |
You need to restore the master database if you are:
a) Rebuilding all your databases from scratch.
b) Changing any server-wide or database configuration options.
c) Adding logins or other login security-related operations.
d) Creating or removing logical backup devices.
e) Configuring the server for distributed queries and remote procedure
calls such as adding linked servers or remote logins.
There is no need to restore your master database, if you just want to restore a user database. For details on Microsoft SQL Server master database, click http://www.microsoft.com/sql/. |
| |
|
| |
|
| |
How do I restore the MS SQL Server master
database? |
| |
Follow the steps listed below to restore the master database:
a) Start Microsoft SQL Server in the 'Single User Mode'.
i). Right-click the Microsoft SQL Server and select 'Properties'. |
| |
 |
| |
ii). Click the 'Startup Parameters' button under the 'General' tab.
|
| |
 |
| |
iii). Select and add the required parameters as shown below.
|
| |
 |
| |
iv). Restart the Microsoft SQL Server. From the SQL Server Enterprise Manager, right-click 'Microsoft SQL Servers', select 'Stop' and then 'Start'.
b) Use the IBackup for Windows SQL Server 'Restore' option to restore the master database. |
| |
|
| |
|
| |
When should I restore the 'model', 'msdb'
and 'distribution' databases? |
| |
Restore the model database if you have changed the database template of your MS SQL Server.
Restore the msdb database if you have changed the scheduling information or want to restore the backup and restore history of your databases. If you are running the replication components of MS SQL Server, then restore your distribution database.
You need not restore these databases if you just want to restore a user database. For more information on Microsoft SQL Server model, msdb and distribution database, click http://www.microsoft.com/sql/. |
| |
|
| |
|
| |
I am receiving an error message stating “VDS::Create Fails : 0x80770005” during SQL Server Backup. Why?
|
| |
The error message implies that your SQL Server service on your computer is running under a start up account with the format .\UserName.
To resolve this issue, contact your System Administrator to configure the startup account of the SQL Server service to use the LocalSystem account. Alternately, use a start up account that has the full name of the domain account instead of a period (.) to start the service.
For example, use the startup account DomainName\UserName to start the service. |
| |
|
| |
|
|
I am receiving an error message stating 'Check registration of SQLVDI.DLL and value of IID' during SQL Server Backup. Why?
|
This message appears when the application tries to use a Sqlvdi.dll file that has not been registered. To resolve this problem, register the Sqlvdi.dll file again using the steps listed below:
1. Stop the SQL Server.
2. Click Start, click Run, type Regsvr32
<path>\SQLVDI.DLL in the Open box and click 'OK'. The default path of the Sqlvdi.dll file is 'C:\Program Files\Microsoft SQL Server\80\COM.'
3. Restart the SQL Server. |
|
| |
|
| Can I restore database files to multiple SQL Server instances? |
Yes. You can restore multiple database files to the MS SQL Server instances one by one. |
|
| |
| |
 |
| |
|
