Two records. SQL Server does not span records across pages.

Allen,

Once you attach the database it is in a recovered state. You may even end up rolling transactions forward or back. To play the transaction log backups the...

Thanks all!

I wasn't expecting a lot of feedback on this one. Not a lot of places deal w/ 'Snapshot' backups so I wasn't expecting much.

We are backing up 500...

This isn't replication I am working with. It is a 'snapshot' backup from a third party tool. To be exact, it is EMC's Timefinder utility. Part...

Let me try to explain a little better.

I have a database that has been attached to a new server. I wish restore transaction log backups to the new database....

lila,

I did the same thing about an hour after I posted my message and it fixed the problem. I am curious as to the security with the xp_logininfo...

Another benefit of seperating your tables/indexes to different file groups is the possibility of getting multiple threads to the disks. Like Frank said, if they are all on...

Lots of good info in all of your posts. Sometimes these threads go astray, but everyone has some good points.

I wish I had my formula for...

Wouldn't rebuilding the indexes in the sysindexes table cause an update to the table? Pointers, dropping and creating the index?

Can you create a test/sample database with only a portion of the data? Might run into some referential integrity issues though. If Foreign Keys aren't important for...

I too have SAP/R3 on SQL Server 2000 (was 7.0).

Even on some of my other RDBMS's I have a lot of fragmentation in my system tables. ...

What are the security risks?

Assuming that the table, data, indexes, and SQL Server versions are identical then the most likely culprit for the difference in execution plans is the statistics.

Look at when...

Thanks for the input everyone!! I have come up with a solution that I feel will work good for us.

I will INIT-ialize the transaction log backup device(file) if the...

I can't find that hot fix to get me to 780..

I seem to get lost at the MS site once too often :-/