Showing posts with label path. Show all posts
Showing posts with label path. Show all posts

Wednesday, March 28, 2012

Need Help about Initial Snapshot

i have created a publication whereas i have provided a network path to its snapshop folder e.g ( \\server\folder ) at time of creating. When i try to make a Pull Subscription and follow all steps of wizards, it gives me following error "The initial snapshot for publication '' is not yet available". can you guide me what are causes of this problem and how may i solve it?

Thanks for help.
Regards,

After you create the publication, you need to start the snapshot agent. The snapshot agent is what creates the files available for subscriptions to use.|||

Dear Greg,

I did the same but when i try to pull the subscription it gives me the error that it can not take the initial snapshot. I also prefer to get snapshots from FTP but it never works. Please help me if you can.

Lookng forward to your reply.

Regards,

|||

Is this merge replication? If so, is it dynamically filtered, which may require a dynamic snapshot to be run?

If you want to use FTP, follow the steps for Configuring a Publication to Allow Subscribers to Retrieve Snapshot using FTP.

|||

Dear Greg,

I am facing the same problem, I am using Merge Replication. After creation of publication when i m trying to connect the server, it gives error of the initial snapshot is not yet available.

|||Just ran into this myself. Once you have everything good, make sure you run the distribution agent. This might fix it. If not, bring up the replication monitor, expand the publications on the left, right-click on the "trouble" server on the right, and check "mark for reinitialization". Then it'll grab the snapshot. You might also need to start the snapshot agent - expand "replication->local publications", right-click on the publication, and select "monitor snapshot agent". Once it comes up, click start.sql

Need Help about Initial Snapshot

i have created a publication whereas i have provided a network path to its snapshop folder e.g ( \\server\folder ) at time of creating. When i try to make a Pull Subscription and follow all steps of wizards, it gives me following error "The initial snapshot for publication '' is not yet available". can you guide me what are causes of this problem and how may i solve it?

Thanks for help.
Regards,

After you create the publication, you need to start the snapshot agent. The snapshot agent is what creates the files available for subscriptions to use.|||

Dear Greg,

I did the same but when i try to pull the subscription it gives me the error that it can not take the initial snapshot. I also prefer to get snapshots from FTP but it never works. Please help me if you can.

Lookng forward to your reply.

Regards,

|||

Is this merge replication? If so, is it dynamically filtered, which may require a dynamic snapshot to be run?

If you want to use FTP, follow the steps for Configuring a Publication to Allow Subscribers to Retrieve Snapshot using FTP.

|||

Dear Greg,

I am facing the same problem, I am using Merge Replication. After creation of publication when i m trying to connect the server, it gives error of the initial snapshot is not yet available.

Wednesday, March 7, 2012

Need a query to get path for last DB backup

Help needed. I need a query (or location of that data so I can write
one) to get the file path information for the last backup taken.
Many thanks.
> Help needed. I need a query (or location of that data so I can write
> one) to get the file path information for the last backup taken.
SELECT TOP 1 mf.physical_device_name
FROM msdb.dbo.backupset AS b
LEFT JOIN msdb.dbo.backupmediafamily AS mf ON b.media_set_id=mf.media_set_id
WHERE b.database_name='HeliosDB'
ORDER BY b.backup_start_date DESC
Tom
http://kbupdate.info/ | http://suppline.com/
|||>> Help needed. I need a query (or location of that data so I can write
> SELECT TOP 1 mf.physical_device_name
> FROM msdb.dbo.backupset AS b
> LEFT JOIN msdb.dbo.backupmediafamily AS mf ON
> b.media_set_id=mf.media_set_id
> WHERE b.database_name='HeliosDB'
> ORDER BY b.backup_start_date DESC
Oops, typo. Right version:
..
..
WHERE b.database_name=N'YourDatabaseName'
..
..
Tom
http://kbupdate.info/ | http://suppline.com/

Need a query to get path for last DB backup

Help needed. I need a query (or location of that data so I can write
one) to get the file path information for the last backup taken.
Many thanks.> Help needed. I need a query (or location of that data so I can write
> one) to get the file path information for the last backup taken.
SELECT TOP 1 mf.physical_device_name
FROM msdb.dbo.backupset AS b
LEFT JOIN msdb.dbo.backupmediafamily AS mf ON b.media_set_id=mf.media_set_id
WHERE b.database_name='HeliosDB'
ORDER BY b.backup_start_date DESC
--
Tom
http://kbupdate.info/ | http://suppline.com/|||>> Help needed. I need a query (or location of that data so I can write
>> one) to get the file path information for the last backup taken.
> SELECT TOP 1 mf.physical_device_name
> FROM msdb.dbo.backupset AS b
> LEFT JOIN msdb.dbo.backupmediafamily AS mf ON
> b.media_set_id=mf.media_set_id
> WHERE b.database_name='HeliosDB'
> ORDER BY b.backup_start_date DESC
Oops, typo. Right version:
.
.
WHERE b.database_name=N'YourDatabaseName'
.
.
--
Tom
http://kbupdate.info/ | http://suppline.com/

Need a query to get path for last DB backup

Help needed. I need a query (or location of that data so I can write
one) to get the file path information for the last backup taken.
Many thanks.> Help needed. I need a query (or location of that data so I can write
> one) to get the file path information for the last backup taken.
SELECT TOP 1 mf.physical_device_name
FROM msdb.dbo.backupset AS b
LEFT JOIN msdb.dbo.backupmediafamily AS mf ON b.media_set_id=mf.media_set_id
WHERE b.database_name='HeliosDB'
ORDER BY b.backup_start_date DESC
Tom
http://kbupdate.info/ | http://suppline.com/|||>> Help needed. I need a query (or location of that data so I can write
> SELECT TOP 1 mf.physical_device_name
> FROM msdb.dbo.backupset AS b
> LEFT JOIN msdb.dbo.backupmediafamily AS mf ON
> b.media_set_id=mf.media_set_id
> WHERE b.database_name='HeliosDB'
> ORDER BY b.backup_start_date DESC
Oops, typo. Right version:
.
.
WHERE b.database_name=N'YourDatabaseName'
.
.
Tom
http://kbupdate.info/ | http://suppline.com/