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

Asger Blond ab-mi at post3.tele.dk
Sun Feb 13 17:21:59 CST 2011


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
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com





More information about the dba-SQLServer mailing list