restore backup database with out sql server management studio -


i have 1 database backup.

now want install backup friend's system.

his system not contain sql server management studio.

how can install backup system, both using sql server 2005.

statement 1: his system not contain sql server management studio

statement 2: both using sql server 2005...

doesn't above 2 statements contradict each other?

update please ignore previous answer

run following command on command promt:

sqlcmd -e -s myserver –q “restore database [mydb]         disk=’d:backupsmydb.bak(your backup databse file)’” 

i got refrence here


Comments

Popular posts from this blog

Delphi XE2 Indy10 udp client-server interchange using SendBuffer-ReceiveBuffer -

Qt ActiveX WMI QAxBase::dynamicCallHelper: ItemIndex(int): No such property in -

Enable autocomplete or intellisense in Atom editor for PHP -