SqlServer inventory Report

Hi,

I want to take a entire inventory report for my legacy sqlserver2000 since i moved all of the databases from sqlserver2000 to sqlserver2005.so,I need to shut down my legacy system in future
would you please send me the script for recording of all inventory(databases,objects,jobs,alerts,logins,users e.t.c) on my legacy system?
chandradineshbabuAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

rob_farleyCommented:
For starters, how about stopping the SQL service and then taking a file system backup of all the data.

Now to script... I'd recommend using a series of loops within SSIS or VBScript/PowerShell, to loop through level by level, grabbing all the info you want.

Won't be trivial, but it will almost certainly be worth doing using something which loops better than T-SQL.

Rob
0
MarcjevCommented:
BACKUP DATABASE [dbname]
TO  DISK = N'C:\path\dbname.bak'
WITH NOFORMAT,
      INIT,  
    NAME = N'dbname-Full Database Backup',
    SKIP,
      NOREWIND,
      NOUNLOAD,  
      STATS = 10
GO
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rob_farleyCommented:
He could backup all databases (including the system ones), but if he stops the services and backs up the whole machine, he could virtualise it and spin up his server when required. That way, he won't lose local Windows users & groups either.

I guess it all depends on what kind of DR plan he needs.

Rob
0
chandradineshbabuAuthor Commented:
yes good
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.