Ha ha, pull your tongue out of his backside will you :Whistling:

Making...

Good luck with the upgrade Wayne, be interesting to...

From BOL

To enable log shipping

➡ Initialize the secondary database by restoring a full backup of the primary database on the secondary server.

➡ On the primary server, execute sp_add_log_shipping_primary_database to add...

I'm...

Problem is, this just causes the database to grow again!! All that I\O to shrink is now...

It's important to note that Kimberley merely advises that...

sais

please post the results of the following query executed against your database

select[FileSizeMB] = convert(numeric(10,2)

, round(a.size/128.,2))

, [UsedSpaceMB] = convert(numeric(10,2)

, round(fileproperty( a.name,'SpaceUsed')/128.,2))

, [UnusedSpaceMB] = convert(numeric(10,2)

, round((a.size-fileproperty( a.name,'SpaceUsed'))/128.,2))

, [DBFileName] = a.name

from sysfiles a

danfugett (11/1/2010)

---

We have a new network share to backup sql files to. We are using the destination format \\10.1.20.50\sqlbackups\Production\foldername. We can get all the backup scripts to backup to this...

does the report use an embedded data source or separate SSRS stored data source? How is this data source configured?

SqlN00bie (11/1/2010)

---

I have created a script to do the log backup for multiple databases instead of using the log-shipping wizzard. This is just so i have less number of...

Parthi

see the attachment below for my instructions on how to configure an SSRS 2008 instance

😎

have you checked the local administrators group on the server?

That link covers SQL Server 2005 not 2008!

romil

which edition of SQL server 2008 are you installing?

which part exactly are you stuck on? I have some configuration instructions if required. SSRS does not actually use IIS any longer although it does still use the kernel mode...