Thank you for your reply. So you think that the backup jobs look to be setup & scheduled correctly but that for this restore I am just missing some...

Thank you both. I added the third file and ran a remove statement on the one I want to get rid of;my answer is that 'yes' I do have to...

Thank you all. The SS2005 view makes it simple! Now if I could snag the definition of that view [sys.triggers] I wouldn't have to rewrite the code to...

Have there been any significant issues reported with any of the cumulative updates? We are planning to apply SP3 -- CU 5 this week and wondered if there is...

Yes. Except for specific applications the users that need to use the linked server connect via their Windows domain account.

The SQL Server 2005 is on Microsoft Windows 2003 R2 Standard 64 Edition, Service Pack 2

The SQL Server 2000 is on Microsoft Windows 2003 Enterprise Edition, Service Pack 2

Both servers...

Thank you. I read the article and will use the script to track down my problem tables. Thank you much.

SQL Server allocates extents to an object. It keeps track of how much space is free or used but it does not release the free space in the extent...

I don't want to use shrink database. I think that SQL Server is similar to Oracle and Informix in that an object is allocated space and that the only...

The results are:

database_size unallocated space

64835.94 MB 38206.49 MB

reserved ...

That is what is different ... right now the log backup writes to a logical device so the only choice was to append or overwrite... I will switch that to...

Not to be dumb but, is the syntax to backup without append 'with init' or do I still use 'with noinit' but have additional syntax for individual log file backup...

I have watched the Activity Monitor while the job was running and it does not show any waittype -- I assume sysprocesses should have the same info

When I tried to...

Gail:

First, thank you for replying.

I don't know why the original DBA created the log with 4 files. They are/were on the same physical drive so there was nothing gained....

Thank you. On another note, is there a prescribed way to prune the tables that contain the backup data? It looks like these tables have never been purged...