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
Post a Comment