Database used space info

I want to get the Database used space info (Count in the
Gray bar NOT the blue) in daily bases. How can I find this
info to put it into a query/script to run it every day. I
don't want the log info, just the dataspace used. Anyone
has an idea or a script to share.
Thanks for any help.Undocumented command DBCC SHOWFILESTATS. I think that is how Enterprise
Mangler populates the graph. I originally found this by reverse engineering
a third-party monitoring tool. I wrote a quick wrapper and dumped the
results to a table (WITH TABLERESULTS works) and report on percentages, etc.
As always, use undocumented DBCC commands at your own risk.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"George" <anonymous@.discussions.microsoft.com> wrote in message
news:011101c3d614$c6dc9260$a401280a@.phx.gbl...
> I want to get the Database used space info (Count in the
> Gray bar NOT the blue) in daily bases. How can I find this
> info to put it into a query/script to run it every day. I
> don't want the log info, just the dataspace used. Anyone
> has an idea or a script to share.
> Thanks for any help.|||I think that is it......
Thanks.
>--Original Message--
>Undocumented command DBCC SHOWFILESTATS. I think that is
how Enterprise
>Mangler populates the graph. I originally found this by
reverse engineering
>a third-party monitoring tool. I wrote a quick wrapper
and dumped the
>results to a table (WITH TABLERESULTS works) and report
on percentages, etc.
>As always, use undocumented DBCC commands at your own
risk.
>--
>Geoff N. Hiten
>Microsoft SQL Server MVP
>Senior Database Administrator
>Careerbuilder.com
>
>"George" <anonymous@.discussions.microsoft.com> wrote in
message
>news:011101c3d614$c6dc9260$a401280a@.phx.gbl...
>> I want to get the Database used space info (Count in the
>> Gray bar NOT the blue) in daily bases. How can I find
this
>> info to put it into a query/script to run it every day.
I
>> don't want the log info, just the dataspace used. Anyone
>> has an idea or a script to share.
>> Thanks for any help.
>
>.
>|||This should help.
http://www.databasejournal.com/features/msaccess/article.ph
p/1467791
Best Regards
Thirumal Reddy Maram
>--Original Message--
>I want to get the Database used space info (Count in the
>Gray bar NOT the blue) in daily bases. How can I find
this
>info to put it into a query/script to run it every day. I
>don't want the log info, just the dataspace used. Anyone
>has an idea or a script to share.
>Thanks for any help.
>.
>

Database Transfermation from SQL 2000 to SQL 2005

Hello
We have two SQL server installation. SQL server 2000 with sp4 and SQL server
2005 sp2. We want tp transfer 2 data bases from SQL 2000 to SQL 2005. how can
we update or transfer Databse from one old version to new version?
best regards,
Thor
Thor
I'd go with BACKUP/RESTORE , however you are able to detach/attach those
databases as well. See the explanation in the BOL
"Thor" <Thor@.discussions.microsoft.com> wrote in message
news:DEE2E28A-2EA8-4532-A2B2-E8F31CB85B3B@.microsoft.com...
> Hello
> We have two SQL server installation. SQL server 2000 with sp4 and SQL
> server
> 2005 sp2. We want tp transfer 2 data bases from SQL 2000 to SQL 2005. how
> can
> we update or transfer Databse from one old version to new version?
> best regards,
> Thor

Database Transfermation from SQL 2000 to SQL 2005

Hello
We have two SQL server installation. SQL server 2000 with sp4 and SQL server
2005 sp2. We want tp transfer 2 data bases from SQL 2000 to SQL 2005. how can
we update or transfer Databse from one old version to new version?
best regards,
ThorThor
I'd go with BACKUP/RESTORE , however you are able to detach/attach those
databases as well. See the explanation in the BOL
"Thor" <Thor@.discussions.microsoft.com> wrote in message
news:DEE2E28A-2EA8-4532-A2B2-E8F31CB85B3B@.microsoft.com...
> Hello
> We have two SQL server installation. SQL server 2000 with sp4 and SQL
> server
> 2005 sp2. We want tp transfer 2 data bases from SQL 2000 to SQL 2005. how
> can
> we update or transfer Databse from one old version to new version?
> best regards,
> Thor|||"Thor" <Thor@.discussions.microsoft.com> wrote in message
news:DEE2E28A-2EA8-4532-A2B2-E8F31CB85B3B@.microsoft.com...
> Hello
> We have two SQL server installation. SQL server 2000 with sp4 and SQL
> server
> 2005 sp2. We want tp transfer 2 data bases from SQL 2000 to SQL 2005. how
> can
> we update or transfer Databse from one old version to new version?
> best regards,
> Thor
Hi Thor
If you are wanting to upgrade check out other posts regarding this such as
http://tinyurl.com/4uzmyl, running the upgrade advisor will show up most of
the potential problems, rebuilding indexes, stats and usage will reduce the
risk of poorly performing queries. If you do have performance issues check
the query plan.
John