May 24, 2010 at 1:02 am
HEY I NEED HELP IN HOW TO RESTORE THE DATABASE SYNTAX IN SQL SERVER 2005..CAN ANY ONY HELP THIS...! ESPECAILLY MOVING DISKS....
I AM HAVING SYNTAX LIKE THIS
RESTORE DATABASE UK
FROM DISK = ' '
WITH MOVE ' Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\UK.mdf',
MOVE ' Data_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\UK_log.ldf'
I AM GETING ERROR LIKE THIS
Msg 3154, Level 16, State 4, Line 1
The backup set holds a backup of a database other than the existing 'UK' database.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
May 24, 2010 at 2:24 am
You can’t use empty strings. Instead of the empty strings you should specify where the backup file is located and which fie you want to move.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 24, 2010 at 5:09 am
backup file located at one server disk and backfile mdb located at other server disk..........
thats is not empty string just name purpose only i leaved it blank...
May 24, 2010 at 6:30 am
Please don't crosspost. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic926640-146-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 24, 2010 at 8:18 am
Edited
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply