microsoft.public.sqlserver.server - Default Backup Directory

Author

Default Backup Directory

Dave

2002-10-31, 6:23 am

Hi

I am writing a stored proc to backup database to the
default backup directory. I am trying to avoid hard coding
the directory in the stored proc. Instead I would like to
use the configured default directory.

Any idea how can I get the default directory into a
variable.

Thanks
Dave

Tibor Karaszi

2002-10-31, 7:23 am

Dave,

Why not quite simply omit the directory?

BACKUP DATABASE pubs TO DISK = 'pubs.bak'

--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver

"Dave" <dave@nodirectmail.com> wrote in message
news:783301c280d6$021f2f30$35e
f2ecf@TKMSFTNGXA11...
> Hi
>
> I am writing a stored proc to backup database to the
> default backup directory. I am trying to avoid hard coding
> the directory in the stored proc. Instead I would like to
> use the configured default directory.
>
> Any idea how can I get the default directory into a
> variable.
>
> Thanks
> Dave

Sponsored Links