Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Exception is thrown while restoring a database

Author  Topic 

shik28
Starting Member

2 Posts

Posted - 2012-02-15 : 02:17:25
Hi,

I have a backup file by name FiVaTech.bak in E: drive. When I try to restore this database, I am getting this exception:

An exception occurred while executing a Transact-SQL statement or batch (Microsoft.SqlServer.ConnectionInfo)

What do I do?

shik28

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2012-02-15 : 03:43:24
Is that the only message?

Try restoring using T-SQL, not the GUI.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

shik28
Starting Member

2 Posts

Posted - 2012-02-15 : 04:12:15
quote:
Originally posted by GilaMonster

Is that the only message?

Try restoring using T-SQL, not the GUI.

--
Gail Shaw
SQL Server MVP


How to do that?

shik28
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2012-02-15 : 05:26:24
Open a query window and write the RESTORE DATABASE statement and run it.

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -