I keep getting a compile error on the VB.NET script saying that a declaration was expected on the 'PublicSub','sMsg','MsgBox' and 'Dts'.

The 'End Sub' is telling me it must be preceded...

No you are not wrong in your thinking.

But it does sound like you have the database 'patients' chosen to have the log backup executed. These databases should not be...

http://support.microsoft.com/kb/933508

• If you create or modify plans or packages by using the original release version of SQL Server 2005, SQL Server 2005 SP1, or the refreshed SQL Server 2005 SP2...

Something like this in T-SQL.

BACKUP LOG ULTIPRO_ACS

TO DISK = 'path\dbname.trn'

WITH NO_TRUNCATE;

GO

RESTORE DATABASE ULTIPRO_ACS

FROM DISK = 'path\yourlastdbbackup_200808192301.bak'

WITH NORECOVERY;

GO

RESTORE LOG ULTIPRO_ACS

FROM DISK = 'path\dbname_2008008190301.trn'

WITH NORECOVERY;

GO

RESTORE LOG ULTIPRO_ACS

FROM DISK = 'path\dbname_2008008190316.trn'

WITH NORECOVERY;

GO

RESTORE LOG...

Excellent, thanks I will start looking into it ASAP.

🙂

Thanks for the replies guys.

What versions support this built-in replication process?

Or is this something that was just introduced in 2007?

I just worked through a similar problem like this, you may have looked at some of this, if you have ignore this post.

1. Look through your application logs on the...

This should work for you, of course enter the proper role you want after the 'EXEC sp_addrolemember' command.

USE [msdb]

GO

CREATE USER [MyUser] FOR LOGIN [MyUser]

GO

USE [msdb]

GO

EXEC sp_addrolemember ‘SQLAgentUserRole’, ‘MyUser’

GO

If the user...

Worked perfect thank you.

Where you dont have anything listed under 'Website' I have 'Default Web Site', maybe the directories for these websites should be under the 'Adminstration Web Site' directory in IIS.

Clicking...

Ya and this is where I think I am having a problem, the Reporting Services were not installed with the original instance or any instance on this server. I...

Now we are getting somewhere, http://servername/Reports

Page not found. I have created only two directories though the Reporting Services Configuration Manager. Being ReportServer and ReportsMngr.

I double checked the prompt given after choosing to deploy through BIDS where it asks for the log in and the path is just how you stated:

http://servername/ReportServer

And yes...

It seems as though the DBA before me removed all the Builtin\Adminstrator accounts from each of the SQL servers stating a security concern.

Is that group the only group that can...

How do I get into 'Report Manager' is that done through Reporting Services Configuration tool?

Sorry for being a bit new at this.