472,368 Members | 2,422 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,368 software developers and data experts.

Restore of Backup problem

Please help

SQL Server 2000 Standard

I am trying to restore databases on my server and am unable to get them
to restore using the database option.

For example, the location of my backup file is:

D:\MSSQL\BACKUP\MY_DB\MY_DB_ddmmyy.bak

But when checking the properties of the restore on the general tab, the
restore shows the correct time and date of the backup we want, but
under RESTORE FROM it states
MY_DB_00__43c6cdc2_06a2_4431_b304_06cc3a97f512_

and not the correct file path. So hence the restore fails with error
"unable to find backup device Device offline".

The only way I can restore is to use the "from device" option then
manually browse to the backup file.

Whilst this is a work around, I want to be able to do point in time
restores which will only work on a database restore.
Any help with this would be appreciated.

Jul 23 '05 #1
3 2130

"butatista" <gm*******@countrywidemobility.co.uk> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
Please help

SQL Server 2000 Standard

I am trying to restore databases on my server and am unable to get them
to restore using the database option.

For example, the location of my backup file is:

D:\MSSQL\BACKUP\MY_DB\MY_DB_ddmmyy.bak

But when checking the properties of the restore on the general tab, the
restore shows the correct time and date of the backup we want, but
under RESTORE FROM it states
MY_DB_00__43c6cdc2_06a2_4431_b304_06cc3a97f512_

and not the correct file path. So hence the restore fails with error
"unable to find backup device Device offline".

The only way I can restore is to use the "from device" option then
manually browse to the backup file.

Whilst this is a work around, I want to be able to do point in time
restores which will only work on a database restore.
Any help with this would be appreciated.


Are you using a third-party backup tool, perhaps? That might explain the
unusual device name you see, and if so then you should probably look into
doing restores using that tool. If you're looking for some sort of
programmatic solution, then you would need to look at the RESTORE command in
Books Online - it accepts variables for the source file name(s) and the time
to restore to, so you should be able to write a stored procedure or script
to do what you want.

Simon
Jul 23 '05 #2
No, I am not using a third party backup tool. I want to do this using
SQL Server and would prefer to use the GUI not a stored procedure or
script.

Thanks

Jul 23 '05 #3

"butatista" <gm*******@countrywidemobility.co.uk> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...
No, I am not using a third party backup tool. I want to do this using
SQL Server and would prefer to use the GUI not a stored procedure or
script.

Thanks


I just tested (SQL2000 Enterprise SP3a) backing up a database to a device
(full backup then a log backups), and doing a point in time restore - it
worked fine, and it displayed the correct file name in the dialogues. If
you're not using a third party tool, then I have no idea where the name
"MY_DB_00__43c6cdc2_06a2_4431_b304_06cc3a97f51 2_" might come from - have you
applied the latest servicepack on the client as well as the server? There
are a number of bugs in the MS KB related to restore operations in EM.

Apart from that, the best idea in the long run is to start using RESTORE for
your recovery operations - it will give you more control and flexibility,
and there are some things which can only be done from TSQL (eg. restore to a
marked transaction). If (when) you need to do batch or scheduled operations,
you will need to do it with RESTORE anyway.

Simon
Jul 23 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Spieg | last post by:
I've a program with VB6 working with SQLServer 2000. I have a Central Station with the program runnin with full prvileges and that can perform all the actions on the DB. There are also some...
2
by: Moti.Ba | last post by:
Hello, I need to restore the Master DB in my SQL 2k server (with sp3). The problem is that i don't have SQL backups of this file I only have general backup of the entire c:\ drive i made using...
2
by: Vikrant | last post by:
Friends, I have read DB2/UDB 8.x 'RESTORE DATABASE Command', with my 'limited' knowledge & skill. I think it should address my concern, but I want advice/ opinion / experience and any care I...
4
by: Hardy | last post by:
hi gurus, now I have to backup and restore a 8 T size db2 database. from two s85 to two 670. the partitions,tablespaces of the db should be redesigned then I plan to use redirected restore. but...
9
by: GL | last post by:
I am running DB2 8.1.1 on AIX 5.1 Having a problem with a redirected restore. Once into the restore continue phase, I immediately get the following SQL2059W A device full warning was...
13
by: Andy K | last post by:
Hi , I'm wondering what's going on with a restore I'm trying to do . My DB2 version is a 7.2 on a Linux RH ES 2.1 . I've copy a recent backup that was on NAS for a test on my machine . I...
0
by: prerak_v_shah | last post by:
Hi All, These days I was working on IBM DB2 database for windows with my .Net Application. Now, it was required to backup database created on one machine to the other machine. I was also able...
6
by: javelin | last post by:
I'm having difficulty searching for an answer to this challenge. Can someone give me a clue on the right keywords to use to find a discussion on this subject? All of the ones I saw appear to touch...
3
by: aka | last post by:
Hi, I'm actually working on the migration of a DB2 unicode db (V8.2 FP 15) from a Sunfire machine with SunOS (64 bit, Big-endian) to an AIX 5.3 (64-bit, Big-endian) server located in US. The...
2
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...
0
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and credentials and received a successful connection...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...
1
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web server and have made sure to enable curl. I get a...
0
Oralloy
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the synthesis of my design into a bitstream, not the C++...
0
BLUEPANDA
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS starter kit that's not only easy to use but also...
1
by: ezappsrUS | last post by:
Hi, I wonder if someone knows where I am going wrong below. I have a continuous form and two labels where only one would be visible depending on the checkbox being checked or not. Below is the...
0
by: jack2019x | last post by:
hello, Is there code or static lib for hook swapchain present? I wanna hook dxgi swapchain present for dx11 and dx9.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.