Asger Blond
ab-mi at post3.tele.dk
Wed Jan 26 04:29:07 CST 2011
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