"babyip" <babyip_at_hot_mail_dot_com> wrote in message
news:4513db82$1@127.0.0.1...
> hello, i am using "Microsoft.SqlServer.Management.Smo" to code a backup
> procedure, as the default backup location is "C:\Program Files\Microsoft
> SQL Server\MSSQL.1\MSSQL\Backup" directory, how can i change the backup
> location to another directory? For example, "c:\backup", thanks!
>

> Hi,
>
> 1. Connect to SQL Server Management Studio
> 2. Right click above the server name and select properties
> 3. Select the database settings:-
> 4. Mention the database default locations to C:\Backup
> 5. Click ok.
>
> Thanks
> Hari
> SQL Server MVP
>
>
> "babyip" <babyip_at_hot_mail_dot_com> wrote in message
> news:4513db82$1@127.0.0.1...
>> hello, i am using "Microsoft.SqlServer.Management.Smo" to code a backup
>> procedure, as the default backup location is "C:\Program Files\Microsoft
>> SQL Server\MSSQL.1\MSSQL\Backup" directory, how can i change the backup
>> location to another directory? For example, "c:\backup", thanks!
>>
>
>