Picture Guide for Restoring .bak DB to MS SQL 2005

[CNDev]

and what server files are you using? and also database?

 

[ReDFoXSuite]

server files also is included where i download my client..

 

[Death Gun]

Error

 

[keeyanz]

TITLE: Microsoft SQL Server Management Studio Express
------------------------------


Restore failed for Server 'ADMIN-PC\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)


For help, click:

You must be registered to see links

------------------------------
ADDITIONAL INFORMATION:


System.Data.SqlClient.SqlError: Directory lookup for the file "C:\tindahan\RanGame1P_Data.mdf" failed with the operating system error 2(The system cannot find the file specified.). (Microsoft.SqlServer.Express.Smo)


For help, click:

You must be registered to see links

------------------------------
BUTTONS:


OK
------------------------------

 

[MarkLopez]

TITLE: Microsoft SQL Server Management Studio Express
------------------------------


Restore failed for Server 'ADMIN-PC\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)


For help, click:

You must be registered to see links

------------------------------
ADDITIONAL INFORMATION:


System.Data.SqlClient.SqlError: Directory lookup for the file "C:\tindahan\RanGame1P_Data.mdf" failed with the operating system error 2(The system cannot find the file specified.). (Microsoft.SqlServer.Express.Smo)


For help, click:

You must be registered to see links

------------------------------
BUTTONS:


OK
------------------------------

On Options Menu When U Are Restoring
change the "C:\tindahan\RanGame1P_Data.mdf" <~ Change The RED To ...
To this ..
c:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ <~ Use this destination if u are only using Program Files (x86) storage

c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ <~ Use this if u are using Program Files Folder. .

Like This ..

 

[rham08]

Thanks!

 

[Xhiao]

Nvm, problem solved.

 

[Rubit Arpes]

succes next step ODBC ryt?

newbie her.

 

[Mohd Farid]

help me solve this...

 

[ServerMaker2013]

. Thank you for share its
guide PICTURE
and Sir do u have a RAN Online pravite server

 

[MrStormccH]

. Thank you for share its
guide PICTURE
and Sir do u have a RAN Online pravite server

yes, he have RAN Online private server

 

[Kim John Lee]

ho to login to MSQL ? ^^

 

[macky1408]

Pa Help bakit may lumabas na TITLE: Microsoft SQL Server Management Studio Express------------------------------


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


------------------------------
ADDITIONAL INFORMATION:


The media family on device 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\RanGame1.bak' is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)


For help, click:

You must be registered to see links

------------------------------
BUTTONS:


OK
------------------------------

 

[raverking]

Pa Help bakit may lumabas na TITLE: Microsoft SQL Server Management Studio Express------------------------------


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


------------------------------
ADDITIONAL INFORMATION:


The media family on device 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\RanGame1.bak' is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)


For help, click:

You must be registered to see links

------------------------------
BUTTONS:


OK
------------------------------

try redownloading the RanGame1? or if it doesn't work try searching the error on google, maybe microsoft can help

 

[ExtraDevelop]

Please recommend a combination of Data 2 servers together.

 

[Tom Sawyer]

pa hinge ng Database ng ep7 thanks !

 

[level29]

try redownloading the RanGame1? or if it doesn't work try searching the error on google, maybe microsoft can help

I'm sure... you are using higher version of MSSQL server than your RanGame1.bak' try to search a 2008 version of RanGame1.bak to resolve your problem..

 

[Tervz]

Hello i have run the Ran Files successfully but my last problem is the user account. I already tried to create gm account MD5 and w/out MD5 but still keep showing the wrong account input. i dont use the release RanGame1 because its error on my sql.

You must be registered to see links

 

[a09167246957]

Hi ive got this problem do you know how to fix this?

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Restore failed for Server 'PAUL-5C2E04EA11\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)

For help, click:

You must be registered to see links

------------------------------
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: File 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\RanGame1.mdf' is claimed by 'RanGame1S_Data'(3) and 'RanGame1P_Data'(1). The WITH MOVE clause can be used to relocate one or more files. (Microsoft.SqlServer.Express.Smo)

For help, click:

You must be registered to see links

------------------------------
BUTTONS:

OK
------------------------------

 

[jeromeirag]

Hi! can you help me guys? I forgot the server name of my SQL so that I can't restore the database.