cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Backup Restore Error

Former Member

on ‎11-27-2013 9:08 AM

0 Kudos

Hello,

We are upgrading our hardware, hence we want restore MSSQL backup to new server with the help of TAPE Drive.

We have installed Win 2008 with MSSQL 2005.

Now we are trying to restore a backup with following steps.

We have created new database

New Backup device configured as Tape (R3DUMP0 =\\.\Tape0)

Right click to database restore from device as tape--> \\.\Tape0--> Ok

After Ok it generate following error message

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

Server Name: pzpsrvr

Error Number: -2

Severity: 11

State: 0

Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. (.Net SqlClient Data Provider)

I have made all firewall related changes.

Please suggest solution

Regards,

Amol dounde

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (1)

Answers (1)

Sriram2009
Active Contributor
‎11-27-2013 1:32 PM
0 Kudos

Hi Amol

What is the Size of the DB? in windows 2008 have you disable the UAC?

Regards

Sriram

Show replies
Show replies
Former Member
‎11-28-2013 4:48 AM
0 Kudos

Hello Sriram,

Size of db is approx 150GB and UAC is not disbled.

Thanks

Amol

Sriram2009
Active Contributor
‎11-28-2013 5:25 AM
0 Kudos

Hi Amol

In SAP installation you must disable the firewall & UAC

In place backup /restore you can move the database by using the deattach & attach method.

1. Stop the SAP application

2. Kindly refer the you tube video http://www.youtube.com/watch?v=gLMPAnSHSwQ

and Microsoft link http://support.microsoft.com/kb/224071

Regards

Sriram

Former Member
‎11-28-2013 6:08 AM
0 Kudos

Hello Sriram,

We are in process of upgrading hardware, we have purchased new hardware for this activity.

We are not disturbing our current setup until we complete backup restore activity.

Also we are not using detach/ attach method for backup restore.

We are simply making use of Tape drive for backup restore as i said above.

Regards,

Amol

Ask a Question