How were you checking to see that the views existed?

In my experience, with full backups, seeing this happen a couple of times in SQL 2000, it was Enterprise Manager not...

I my experience the transaction log size can be 2-3 times the size of the modifications within the database, depending on the type of modifications. The updates are the worst...

I have it partially figured out. First, I found that the "Local System" account IS able to access network resources, in Win 2003, under the name Domain\ComputerName$. This is a...

Just something stupid I ran across.

If you migrate the packages to a name instance of SQL Server 2005, the migration program will allow it, but you'll never be able to...

You have a security problem, most likely, because SSRS in the Standard edition does have subscription capabilities. All I run here is Standard edition and I have subscriptions running just...

When in a report, you should see "New Subscription" at the top of the report. Click this and you will see the subscription options, including scheduling for said subscription.

If you...

OK, now I wonder about the SID used for the System account. Can it be that the SID is the same for all installations of Win 2003, since it is...

I have found something odd, that I believe is related to the log shipping. The secondary server is attempting, unsuccessfully, too log in to the Monitor SQL Server. I am...

This apparently is not specific to log shipping. I just ran this TSQL from ServerA:

Backup Database MDSS To Disk = '\\ServerB\Share\MDSS2.bak' With Init, Stats=20

Results:

Processed 352 pages for database 'MDSS', file...

ServerA, the principal, is dumping the backups to \\ServerB\Share, and the share rights are Everyone Full controll, and ACL is Admins Full Control, Creator Owner Special permissions, Everyone List Folder...

Wow, this is new to me. I had not thought of that before, and obviously did not know it was possible, switching back and forth between Bulk and Full. I've...

Tim,

Are you saying that reindexing takes up less or no space in the log when you have the DB set to the "Bulked logged" recovery model?

Thanks,

Chris

I'm gonna go out on a limb here, because I have done it before, and say to check the spelling of your mail server. I noticed above you put it...

Not sure I understand. If you are adding a domain account there is not PW to add, as a domain account PW is not stored in SQL Server.

Are you saying...

That's the screwy thing I can't figure out. All services on all boxes are running as the "Local System" account, with the exception of the source server, housing the Principal...