How restore BAK file?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill - 31 Aug 2007 21:46 GMT

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

Reply to this Message

Ekrem Önsoy - 31 Aug 2007 21:27 GMT

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.

Signature

Ekrem Önsoy

> 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.
[quoted text clipped - 11 lines]
> thanks,
> Bill

Reply to this Message

Tibor Karaszi - 31 Aug 2007 22:28 GMT

You 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.

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

> 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.
[quoted text clipped - 10 lines]
> thanks,
> Bill

Reply to this Message