Restoring from backup - *** INPOMPLETE ***

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 2005 Forums

SQL Server Administration (2005)

Restoring from backup - *** INPOMPLETE ***

Author

Topic

Ernest
Starting Member

2 Posts

Posted - 2011-04-04 : 05:59:15

Hi, I have a problem with restoring database from backup on Express version.

Backup was created on SQL 2005 Standard Server (contains full-text-index). When I try restore this on the same server, all is right.

But when I tried restore this copy on my MS SQL 2005 Express, something is wrong. When in Managment Studio I will choose "Restore Database", and next I select (*.BAK) file, value of name is: *** INPOMPLETE ***, and is no more detail..

Is possible, that problem is with my Express version ?

Please for help... Great thanks!!

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-04-04 : 10:47:33

Try using T-SQL RESTORE command.

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2011-04-04 : 11:57:39

RESTORE DATABASE [AdventureWorks] FROM DISK = N'D:\YourFolderPath\AdventureWorks.bak'
WITH FILE = 1,
MOVE N'AdventureWorks_Data' TO N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\AdventureWorks.mdf',
MOVE N'AdventureWorks_Log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\AdventureWorks.ldf',
NOUNLOAD, REPLACE, STATS = 10

--------------------------
http://connectsql.blogspot.com/

Ernest
Starting Member

2 Posts

Posted - 2011-04-05 : 04:59:09

RESTORE DATABASE [rrrrrrr] FROM DISK = N'C:\1\Apr.30.11.M_Eurobasket.bak' WITH FILE = 1,
MOVE N'M_Eurobasket_dat' TO N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\rrrrrrr.mdf',
MOVE N'M_Eurobasket_log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\rrrrrrr_2.ldf',
NOUNLOAD, REPLACE, STATS = 10

SQL Response is:

Msg 1834, Level 16, State 1, Line 1
The file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\M_Eurobasket_1.ndf' cannot be overwritten. It is being used by database 'M_Eurobasket'.
Msg 3156, Level 16, State 4, Line 1
File 'M_Eurobasket_log2' cannot be restored to 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\M_Eurobasket_1.ndf'. Use WITH MOVE to identify a valid location for the file.
Msg 1834, Level 16, State 1, Line 1
The file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\M_Eurobasket_3.ldf' cannot be overwritten. It is being used by database 'M_Eurobasket'.
Msg 3156, Level 16, State 4, Line 1
File 'M_Eurobasket_log3' cannot be restored to 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\M_Eurobasket_3.ldf'. Use WITH MOVE to identify a valid location for the file.
Msg 3634, Level 16, State 1, Line 1
The operating system returned the error '5(error not found)' while attempting 'OpenForRestore' on 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\M_Eurobasket_4.FSIndex\SQL.HDR'.
Msg 3156, Level 16, State 2, Line 1
File 'sysft_FSIndex' cannot be restored to 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\M_Eurobasket_4.FSIndex'. Use WITH MOVE to identify a valid location for the file.
Msg 3119, Level 16, State 1, Line 1
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2011-04-05 : 07:03:55

execute following query to get files list, so we provide you accurate script
RESTORE FILELISTONLY
FROM DISK = 'C:\1\Apr.30.11.M_Eurobasket.bak'

--------------------------
http://connectsql.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources