Thursday, March 29, 2012

How restore BAK file?

We use Avaya IP Office. Call records are stored in programs such as Delta
Server and Database Server Supervisor and backed up with SDX Archiver.
Avaya says it's using Microsoft's SQL database.
Question: How do I restore a database? I have a .BAK file that I need to
restore, to try to retreive some data. Avaya says it's a standard Microsoft
SQL backup.
Can someone tell me how to restore this backup? I know Windows, but I've
never used any flavor of SQL.
thanks,
BillYou can read about the RESTORE DATABASE command in Books Online. If you are totally new on SQL
Server, I suggest you pick up a book at appropriate level, that will save you lots of time.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Bill" <Bill@.discussions.microsoft.com> wrote in message
news:01FB537F-9227-485F-9A4D-D23CB8EB3718@.microsoft.com...
> We use Avaya IP Office. Call records are stored in programs such as Delta
> Server and Database Server Supervisor and backed up with SDX Archiver.
> Avaya says it's using Microsoft's SQL database.
> Question: How do I restore a database? I have a .BAK file that I need to
> restore, to try to retreive some data. Avaya says it's a standard Microsoft
> SQL backup.
> Can someone tell me how to restore this backup? I know Windows, but I've
> never used any flavor of SQL.
> thanks,
> Bill|||Hi Bill,
If you don't know SQL Server, then you must be unawared of Books Online...
Here, you can find info regarding to Backup and Restore in SQL Server 2005
under this topic.
http://msdn2.microsoft.com/en-us/library/ms187048.aspx (This is Books
Online)
If you need further help, we are around here.
Ekrem Ã?nsoy
"Bill" <Bill@.discussions.microsoft.com> wrote in message
news:01FB537F-9227-485F-9A4D-D23CB8EB3718@.microsoft.com...
> We use Avaya IP Office. Call records are stored in programs such as Delta
> Server and Database Server Supervisor and backed up with SDX Archiver.
> Avaya says it's using Microsoft's SQL database.
> Question: How do I restore a database? I have a .BAK file that I need to
> restore, to try to retreive some data. Avaya says it's a standard
> Microsoft
> SQL backup.
> Can someone tell me how to restore this backup? I know Windows, but I've
> never used any flavor of SQL.
> thanks,
> Billsql

No comments:

Post a Comment