Backup and restore from Commandline

[cricketer1]

Is it possible to perform admin tasks in SQL Server such as backup or restore from commandline. If so how can I restore a transactional log file from DB 'A' to DB 'B' on commandline.

Thanks
cricketer1

 

[lemosley01]

Check out the OSQL utility - that allows you to run queries from the command-line. You can find information on it in SQL Books Online, or open a command prompt and enter "osql /?"

Sounds like you are talking about creating a standby server using log shipping. If you are using SQL 2000, it has support for log shipping built-in. See the log shipping topic in books online.

 

[cricketer1]

thanks for pointing me in the right direction. actually log shipping was not the end objective, but you have given me an alternate to my initial approach.

Thanks
ceicketer1