Not at all.

A well asked question often leads...

Right click jobs -> New Job -> Steps -> New -> Type: CmdExec -> Command: c:\MyFolder\Program.exe

As I recall, when creating the publication, there is a setting something like:

1) Create snapshot now

2) Create snapshot later on demand

3) Use existing snapshot files or snapshot already exists.

I...

You can create a linked server, then

insert into Server_B.Database_B.dbo.Table_A

select * from Database_A.dbo.Table_A

"...when i first start the replication, the shapshot is copy to the subscriber. after that, the shapshot will not ever be used...."

Correct, but in your first post you...

murgocimark (11/18/2009)

My first question is that this approach is correct, than:

- i know than in a replication, its recommanded than dailly to perform a snapshot replication also, for that the...

If the job is failing, you should configure it to send you an email notification.

I think failed jobs would be in job history, not backup history.

To double check your current...

You could run this to look for unused index that might be candidates for deletion. Keep in mind that the info in sys.dm_db_index_usage_stats is only accurate since the last...

Since t-log backups...

Thanks ! That was it.

Interesting ! ...

I use this to search for character strings in stored procedures:

select name, create_date, substring(definition,CHARINDEX('CharacterString', definition)-25,150) as 'Code Snippet', definition as 'Entire Code'

from sys.sql_modules com

join sys.objects obj on com.object_id...

Is this the target database that is receiving logs from log shipping ?? If so, I think you want it to stay in NORECOVERY so it can accept more...

Can you access the database through the GUI ?? See all the tables & data ?

I like to keep the backup history information. I find it useful for analyzing database growth over time. It doesn't take up much space, why not leave it there ?