Backing up a database problem - SQL Server Forums

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

SQL Server 2000 Forums

SQL Server Administration (2000)

Backing up a database problem

Author

Topic

bkmurti
Starting Member

13 Posts

Posted - 2002-08-30 : 23:06:56

i have backed a database for example ABC which is on NT
server.
now i want to copy and restore it on win 98SE system .on
this system there is no structure of ABC created.

i gave the name "abc" in the textbox "Restore as database"
selected " From device" in restore
in parameters i gave the name of backupfile "ABC.mdf"
and in restore backupset i selected " database - complete"

when trying to restore it gave message

" the file \mssql7\data\abc.mdf" cannot be used by
RESTORE. Conside ysing the WITH MOVE option to identify a
valid locarion for the backup or restore operation
terminated abnormally"

why dis the message come,how to solve the problem, and
when i need to dump a database at another location what is
the process should i take

bye
gopal

chadmat
The Chadinator

1974 Posts

Posted - 2002-08-31 : 02:35:30

Do as the message says, use the with move option.

Restore database abc from disk = 'blah'
with move 'abc_data' to 'c:\blah\abc.mdf',
move 'abc_log' to 'c:\blah\abc.ldf'

-Chad

lozitskiy
Starting Member

28 Posts

Posted - 2002-09-03 : 09:58:48

You wrote:
i gave the name "abc" in the textbox "Restore as database"
selected " From device" in restore
in parameters i gave the name of backupfile "ABC.mdf"
and in restore backupset i selected " database - complete"
-----------------
Before restoring - click on tab Options and change folders for your database in column 'Restore As'. Folder must exist on disk.

-------------
MCP MSSQL

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources