How to backup/ restore MS
SQL Server database files using IBackup
Professional?
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. 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. 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.
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, 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,
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.
Why am I getting the error message “Check registration of SQLVDI.DLL and value of IID” during SQL Server Backup?
This message appears when the application tries to use a Sqlvdi.dll file that has been unregistered. To resolve this problem you need to re-register the Sqlvdi.dll file. Follow the steps 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 SQL Server
