Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Path of backup files

Author  Topic 

vicki
Posting Yak Master

117 Posts

Posted - 2002-04-11 : 16:06:00
What is the command to find out where is Path of backup files? andDate Last updated/used? for databases?

thanks

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2002-04-15 : 20:23:21
During the backup, you specify the path to the backup files as the "device". And when you go to restore you do the same. You can also add the WITH MOVE option to the restore to place the restored files into a particular location.

As for the Date Last Updated/used for an entire database... I don't think there is such a thing, but I could be wrong on that.

------------------------
GENERAL-ly speaking...
Go to Top of Page
   

- Advertisement -