I still have the same question and Iam not claer how all the DBA's schedule the Backups. For Our Backup startegy Could you please tell me how can I schedule...

Hi Krishna,

We have our backup strategy as below: We are following this strategy to keep the data loss minimum in case of any disaster

1. Full backup dailly at 1:00AM

2.Diffrential...

John,

We do not have any Linked servers. We have only ine Remote server.

You want me schedule the log backup every hr starting from 2:01AM(1 min past 2:00AM)

Then diff backup will occur at 5:00AM and log backup will occur every hr like 2:01,...

Could you please tell how to add multiple recepients through the database mail GUI

Yeah....I have succesfully Moved reporing services from one sql server 2000 to other sql server 2000 and also upgraded to 2005 succesfully.

I will put together steps and post here soon.

Many...

Microsoft search hasbeen installed and running but it looks like we are not using this feature because there are NO fulltext itmes in Enterprise manager->local(windows NT)->Support Services->Fulltext Search

and also We...

Thanks Peddie,

I have checked the sql server 2000 in Enterprise manager->local(windows NT)->Support Services->Fulltext Search

There No items in the Fulltext Search. So its means that the sql server 2000 instance is...

Thanks,

I upgraed to sql server 2005 and did the corrective action for the full text search as upgrade adviser says. But now How can i make sure the full text...

I followed the below steps:

To move a SQL Server 2000 Reporting Services database to another computer and to make Reporting Services point to that database, follow these steps:

Back up the...

thanks peddie,

Here all the links explaining about how to migrate reporting services from sql server 2000 to 2005. But I need to migrate reporting services from one sql server 2000...

Hi,

Could you plz tell me the srteps to move sql server 2000 reporting services standard edition from one server to other(SQL server 2000 standard edtion).

I tried all the option in...

1.Install reporting services in New server.

2.Delete the ReportServer n ReportServerTempDb and restored the ReportServer n ReportServerTempDb from Old Server.

3.run the following command at a command prompt on the computer that...

hi,

I got it..for reporting services 2000, there are 2 service packs

1.SP1

2.SP2

hi,

http://msdn.microsoft.com/en-us/library/ms143724.aspx

http://msdn.microsoft.com/en-us/library/ms156421.aspx

http://www.developmentnow.com/g/115_2004_10_0_0_452440/Moving-RS-To-A-New-Web-Server-Problems.htm

followed the above links and I did the following

1.Install reporting services in New server.

2.Delete the ReportServer n ReportServerTempDb and restored the ReportServer n...