| Author |
Topic |
|
Sachin.Nand
2937 Posts |
 Posted - 2011-01-10 : 01:23:31
|
| Hi All,I have a Transactional replication set up.I need to change the Snapshot folder location.I cannot find any option to do so..PBUH |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-01-10 : 05:17:21
|
In the properties of the publication, if you select the Snapshot details it will let you change the folder of the snapshot. Was this what you were asking about...? I have a feeling it wasn't... - LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
 |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-01-10 : 07:09:15
|
| You have understood the question right.But when I uncheck the checkbox and put the desired path it just does not seem to get changed.I have admin level privilages.PBUH |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-01-10 : 08:09:10
|
| Have you tried the system stored procedure sp_changedistpublisher -> http://msdn.microsoft.com/en-us/library/ms186749.aspxEXEC sp_changedistpublisher 'working directory', 'd:\newSnapshotFolder'- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-01-12 : 00:19:32
|
| I did try that to but still the path fails to change.PBUH |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-01-12 : 01:04:53
|
| Is the new path valid? You're using a local path and not a remote unc path?Can you script out the publication and post it? |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-01-12 : 02:02:24
|
| I am using the remote unc path.It has permission to SQL Agent service account.PBUH |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-01-12 : 03:35:28
|
| What about trying to change it to a different local directory just for "fun" to see if that works...? Do you get any error messages?- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-01-12 : 03:36:11
|
| ...or try to to map the UNC path to a local drive letter?- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-01-12 : 05:28:38
|
quote:
Originally posted by Lumbago
...or try to to map the UNC path to a local drive letter?- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com
I am not to sure how to do that.Also I dont have access to the database server so I cannot change it to local directory .PBUH |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-01-12 : 11:31:34
|
| If you don't have access, you can't change the snapshot folder location at all. |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-01-12 : 23:37:41
|
| No what I meant was I dont have physical access to the database server machine.PBUH |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-01-13 : 03:27:21
|
| You can still change the path to a local folder even though you don't have direct access to the server. Just try to change it to a folder you know exists, just to see if it gets changed at all. Change it to something like c:\windows or c:\program files\ or something... If that doesn't work I'm out of ideas.- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
|
|
|
|
Changing the Snapshot location