[dba-SQLServer] RV: Change default backup destination and reductionof log file size

Asger,
Yes, it was! Very helpful.
In SSMS it's not that intuitive - and searching BOL got me nowhere.
That's why this list is what it is: indispensable
I've been on this list for about 10 years and it has been a life saver
on many occasions. I agree that it would be a good idea to follow up
with a 'problem solved' message when appropriate with a summary of the
issue and how it was solved, or just a heads up when a reply was
helpful.
Regards
Borge

On Monday, February 14, 2011, Asger Blond <ab-mi at post3.tele.dk> wrote:
> Was this response of any help to you?
> Asger
>
> -----Oprindelig meddelelse-----
> Fra: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] På vegne af Asger Blond
> Sendt: 26. januar 2011 11:29
> Til: 'Discussion concerning MS SQL Server'
> Emne: Re: [dba-SQLServer] Change default backup destination and reductionof log file size
>
> In SSMS rightclick the server name - choose Facets - then in BackupDirectory enter the destination folder.
> Notice that this will only be the default backup folder for databases you have not previously backed up - for previously backed up database you have to change the destination manually.
>
> As for reducing the log file you have to make a BACKUP LOG - a full database backup won't reduce the log file.
>
> Asger
>
> -----Oprindelig meddelelse-----
> Fra: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] På vegne af Borge Hansen
> Sendt: 26. januar 2011 05:24
> Til: Discussion concerning MS SQL Server
> Emne: [dba-SQLServer] Change default backup destination and reduction of log file size
>
> I recently installed the web server version of SQL 2008 R2, and as
> part of installation I must have specified the default backup
> destination folder.
> I've restored three SQL 2005 DBs and all is good.
> I moved the backup destination folder though in the file / folder system.
> Now whenever I do a simple full backup the Management Studio is
> serving up the location of the old now non existing backup folder.
> Simple question: How and where do I change the default backup
> destination setting?
>
> Also, One Db has a mdf file of 750mb and the logfile is about 500mb.
> How do I reduce the size of the logfile? I thought that performing a
> simple full backup would automatically reduce the logfile.
>
> Thanks,
> borge
> _______________________________________________