Diaster Recovery - Different Build Numbers

I have to test for a diaster recovery plan (in case the
building burned down) We do a full backup of the data
files on our SQL Server 2000 nightly. (Using Veritas with
SQL client) My job is to build a new server and restore
the databases. All is find until I try to restore the
master. Then I get the error that the build numbers are
different. I have applied all the service packs and
patches that I believe to be on the original box, but
cannot get the build numbers to match. Does MS list what
patches or updates are in which build numbers?
ThanksChris,
See if this helps
SQLSecurity Checklist
http://www.sqlsecurity.com/DesktopDefault.aspx?tabindex=3&tabid=4
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Chris" <chris.mcbirney@.go.doe.gov> wrote in message
news:581b01c376ff$9a59f2b0$a501280a@.phx.gbl...
> I have to test for a diaster recovery plan (in case the
> building burned down) We do a full backup of the data
> files on our SQL Server 2000 nightly. (Using Veritas with
> SQL client) My job is to build a new server and restore
> the databases. All is find until I try to restore the
> master. Then I get the error that the build numbers are
> different. I have applied all the service packs and
> patches that I believe to be on the original box, but
> cannot get the build numbers to match. Does MS list what
> patches or updates are in which build numbers?
> Thanks

Diagrams

I know that the BI studio can build a nice flow document that is associated with the package. Is there an easy way to build a series fo documents that can be shared with other users without having them go into Visual Studio?

Mark E. JohnsonI have an upcoming presentation and was wondering if there were any methods/features that could display all the SSIS packages, tasks, dataflows, relationships, and such in a functional diagram? Similar to what is seen in a ERD diagram. If not, are there any functions or tools that can help collage these SSIS displays (outside of screen shots)?|||We are building a tool that will traverse IS packages, SQL Server Databases, and AS to get metadata reports. It should be available around the time we ship.
It's called the "SQL Documenter"...
Thanks,
K|||

Has a timeframe been defined yet?

Thanks Kirk.

|||

Yes, around the time that Yukon ships.
K

|||

KirkHaselden wrote:

We are building a tool that will traverse IS packages, SQL Server Databases, and AS to get metadata reports. It should be available around the time we ship.
It's called the "SQL Documenter"...
Thanks,
K

Now that SQL Server 2005 has been released is there any news on this tool? I have been looking around for it but with no luck.

-Sune|||

The documenter is a "sample" application, not a released product, so there is no firm release schedule for it.

It's not quite ready yet. It should be quite soon, but I don't have a better estimate just now.

Donald

|||Thanks Donald. I'm looking forward.

If you need an external beta tester just let me know :o)

- Sune|||Has there been any new progress made on releasing this tool yet?|||

Did you find anything about your request?

I am looking for a SSIS Documenter too!

|||The DTS documenter was there for a while:
http://www.softrus.org/dts/

And I got a note that SSIS Documenter is coming from these guys as well.|||

Any updates on this?

|||

I found the following free tool.

http://www.bidocumenter.com/Public/Default.aspx

Development Tools

Are there any tools (other than Visual Studio.NET) that will allow me to
build SQL Reporting Services Reports? I just want to build some simple
reports and don't need (or want) to install the Visual Studio.NET.SQL Server 2005 will include a new tool called "Report Builder" that is
intended for end-users. It doesn't depend on VS.
--
Rajeev Karunakaran [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"John" <John@.discussions.microsoft.com> wrote in message
news:43A3C15E-9042-4204-BB90-CFA8A0BE86EA@.microsoft.com...
> Are there any tools (other than Visual Studio.NET) that will allow me to
> build SQL Reporting Services Reports? I just want to build some simple
> reports and don't need (or want) to install the Visual Studio.NET.