I am very new to SQL and currently have SQL 2000 installed on a 2000 server platform. I have a backup of my database (.dbk and .bak file) that I would like to restore to another machine at a remote location. I know how to do a normal restore, but I would like to be able to do a restore from the command line. Is this possible. I would like to be able to take the CD containing the dbk and create a blank database on another computer and then restore that dbk to the newly created database to build all the indexes and tables. Can I do this? If so, could someone please help me out. My databases are all using windows authentication mode.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
command line restore of a SQL 2000 dbk
- Thread starter ccampbell
- Start date
Similar threads
- Locked
- Question
- Locked
- Question