Pau Lo
asked on
SQL mdf, ldf and backup locations
If you have a SQL 2005 instance with 30 databases. Is there any easy wat to determine where on disk the actual database and log file is located, and also where the backup file is being written to?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I assume you can declare where you want the backup file to be saved to?
Providing you are scripting out the backups you have total control of where the backups are saved.
Providing you are scripting out the backups you have total control of where the backups are saved.
ASKER
What about backup files when using the native SQL backup utility? I assume you can declare where you want the backup file to be saved to?