|
| Backup related Questions |
| |
How to backup/
restore MS SQL Server database files using IBackup Professional?
Please visit the MS
SQL Server Backup page to view the steps involved
in backing up your MS SQL Server database files.
IBackup Professional provides two options to restore
MS SQL Server database files from your account into
your MS SQL Server. Please visit the MS
SQL Server Restore page to view the steps involved
in restoring your MS SQL Server database files. |
 |
|
Under what extension is the
MS SQL Server backup files stored in IBackup Professional
account?
The backed up files are stored in
your IBackup Professional account with the extension
'. dmp’. The file name will be enclosed within
square brackets.
Format of the file name is as shown here:
[<name of database>]. dmp
For ex: [employee]. dmp, [pubs]. dmp. |
|
|
Can I backup
databases from multiple instances of MS SQL Server?
Yes, you can backup databases from multiple instances
of MS SQL Server which are running on your local computer.
However, you may not be able to backup databases from
multiple instances of MS SQL Server which are hosted
at multiple locations in your network. |
|
|
I am not able to
view the databases in the instance of MS SQL Server
I have logged into, why?
This may be due to lack of proper access permissions
for the username that you are currently logged in with.
Under such circumstances, you might not be able to view
all the databases under that instance. Please contact
your database administrator to get the proper access
privileges to access the databases. |
|
|
Can I backup MS SQL Server 'tempdb'
database?
No, you cannot backup your MS SQL Server 'tempdb'
database. |
|
|
Can IBackup Professional
backup the entire SQL Server database?
Yes, you can backup the entire database
that has been selected for backup along with the corresponding
database log file to your online IBackup Professional
(with '[<database name>]. dmp’). The backed
up database (*.dmp) file contains the entire structure
and component of selected database and the corresponding
database log file.
Please note that you may backup multiple
databases also wherein each database will have its own
corresponding '[<database name>]. dmp’ file. |
|
|
In what circumstances
should I restore the MS SQL Server ‘master’
database?
You need to restore the `master’
database if you are doing the following:
a. Rebuilding all your databases from scratch
b. Changing any server-wide or database configuration
options
c. Added logins or other login security-related operations
d. Created or removed logical backup devices
e. Configured 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 more information on Microsoft SQL Server ‘master’
database, please visit http://www.microsoft.com/sql/. |
|
|
How do I restore
the MS SQL Server `master’ database?
The following steps will help you
to restore the `master database.’
a. Start Microsoft SQL Server in the `Single User Mode’
i). Right click on your Microsoft SQL Server and select
`Properties’
|
|
ii). Click on the 'Startup Parameters' button under the
‘General’ tab
|
|
iii). Select and add the required parameters as shown
below
|
|
iv). Restart Microsoft SQL Server. From the SQL Server
Enterprise Manager, right click on `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?
You should restore the `model’
database, if you have changed the database template
of your MS SQL Server. You need to restore the `msdb’
database, if you have changed the scheduling information
or you 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 do not have to restore these databases,
if you just want to restore a user database. For more
information on Microsoft SQL Server `model,’ `msdb’
and `distribution’ database, please visit http://www.microsoft.com/sql/. |
|
|
Can I perform backups of MS SQL Server related files using the Open file Backup feature?
Yes, you can. However, it is highly recommended that you use the separate features available with IBackup Professional for consistent backup of MS SQL Server related files. |
|
|
I am receiving an error message “VDS::Create Fails : 0x80770005” during SQL Server Backup. Why?
The error message "VDS::Create Fails : 0x80770005" is appearing during SQL Server backup due to the reason that the SQL Server service on your computer is running under a startup account that has the format .\UserName.
In order to resolve this issue, we recommend you to contact your System Administrator to configure the startup account of the SQL Server service to use the LocalSystem account. Alternatively, use a startup 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. |
|
|
|
Copyright
© 2007, Pro Softnet Corporation. All rights reserved.