Tag Archives: folder

Sql Server Tutorials

How to change default snapshot folder for Replication?

Scenario

You’ve set up replication initially by using the GUI and accepting all defaults and now due to growth you need to change your default replication snapshot folder location to another drive since the current location is a local disk and cannot be expanded to accommodate the growth.

This concerns you as you cannot afford downtime to perform a re-initialization of all your existing subscribers as they are needed to run the business.

Solution

You can change the snapshot location without having to perform a re-initialization. The only caveat to this is you do need to generate a new snapshot. This snapshot will not be applied to your subscribers, but has to go through the generation process. I recommend doing this at night or weekends to minimize the impact of the snapshot agent locking tables and contention on the publisher database. Continue reading How to change default snapshot folder for Replication? →

Sql Server 2008, Sql Server Tutorials

How to change the Sql Server backup folder

Scenario proposal
When you install SQL Server the path for the installation is generally something such as the following: C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL.

In this directory there are also folders for your DATA files and also your BACKUP files.  Within SQL Server Management Studio you have the ability to change the default location for your Data and Log files for all new databases, but you can not change the default directory for your backups.

Is it possible to change the default directory for backups, so it does not need to be specified each time I run a backup?

Continue reading How to change the Sql Server backup folder →