hi,fyi

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/508c686d-2bd4-41ba-8602-48ebca266659.htm check it pls

but pls note that y do u need to perform logshipping b/w 2 instances in the same server??? it does not server the purpose of logshipping,coz u need a standby...

hi,

   yes u can configure logshipping in sql 2005 b/w 2 instances in the same server,with local system account. in that case u dont...

pavan,

        to send database mails you must be a member of the DatabaseMailUserRole database role in the msdb database,also check if the mail server is up.....and ensure that port 25...

hi dude,

           what i meant to say was if u perform any data modification operations (DML) i.e if u create a table in the log shipping db in source and...

Also do check the error log and job history details,u shud get a clear idea.....also refer the URL, http://support.microsoft.com/kb/321247 mite be useful

Hi,

  These are the below steps in performing log shipping,

1) On primary server, create a shared folder. Eg: c:\log

2) Backup the database on primary server to shared folder. (The...

Hi,

pls refer the below link,

http://msdn2.microsoft.com/en-us/library/ms143393.aspx

Hi,

   I tried in the enterprise manager,by adding the startup parameter as

-c -m -T3608.......and then gave a service restart,the sql server started but not in single user mode,hence i was...

hi friends,

             u cannot downgrade ur box from  a higher version to a lower version..........u cant restore 2005 db to sql server 2000......there is no way to downgrade it to...

did u refresh it ????? else check it in sysaltfiles.........

select * from master..sysaltfiles

Hi Greg,

          pls refer the below link,

http://blogs.msdn.com/arvindsh/archive/2007/06/15/the-role-of-stopat-in-restore-database.aspx

Hi Guyz,

           y do u need to go for logshipping b/w sql 2000 to sql 2k5.......it doesnt server the purpose of logshipping by confuguring it b/w 2000 to sql 2005 as...

Hi,

   Use With INIT keyword to overwrite the backup file instead of With NOINIT..

Hi Dude,

           From the job history info it seems ACI\snasir is the owner of the job.But u say that sqlserver agent seems to run in different account name.So y dont u...