Showing posts with label company. Show all posts
Showing posts with label company. Show all posts

Wednesday, March 28, 2012

Please help ~~~

Please help , my company's SQL server database grow so quick , a few day grow 20G, does any tools or server can compress the database ?

Please help me ~~~~

silver
e-mail : silvershi@.gmail.com

Hi Silver,

did you mean the *.mdf File (Datafile) or the *.ldf (Transaction-Logfile)?

|||

try shrink that db

DBCC SHRINKDATABASE ( 'database_name' | database_id | 0 [ ,target_percent ] [ , { NOTRUNCATE | TRUNCATEONLY } ] ) [ WITH NO_INFOMSGS ] if the log growed unexpectedly the command can be BACKUP LOG { database_name | @.database_name_var } WITH { NO_LOG | TRUNCATE_ONLY } [;] this truncate the logAnyway, all depends by many factors as recovery model, the activity on your server, if there is bulk insert of data etc.|||

If I were to guess, you are using full recover model and what is growing is probably your transaction log. The way to deal with that is to backup your transaction log. If you aren't in production, don't need point in time recovery and can afford to lose data, you may want to explore simple recovery model.

That's the simple answer if that is your configuration. A lot of other issues come into play in deciding your recovery model, frequency of backups, etc.

-Sue

|||I means the *.ldf( Transaction-LogFile)

what's can I do ? nowaday the transaction-LogFile is 120G , it so large my sql server just have 60G free now ....
|||thanks for all , I have find a doc. to do this .....

http://support.microsoft.com/?scid=kb%3Ben-us%3B272318&x=10&y=8

thank for your help ~~



|||

This is a very common prob in SQL Server. The growth of Transaction Log(TL) is depends on couple of things... (a) the Recovery Model (b) TL Backup freqency.

(a) first check whether you need Full recovery model , if not change it to Simple

(b) WHat is the Backup policy. if you are taking the TL backup then increase the frequency of the TL backup

(c) If you want to shrink the file then you will have to truncate and shrink it. After truncating and shrinking the first step should be a full backup. otherwise the backup chain will break and u will not be able to restore from TL bakcup.

Refer :

http://support.microsoft.com/kb/873235.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1542414&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1630021&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1623857&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1447193&SiteID=1

Madhu

|||thanks for you help , but I have a question ...
if I shrink the log file , is it have any effect about my data in the database ?

thanks

|||

Hi Sivershi,

normaly no!

But you have to think about Madhu K Nair questions - backup policy, recovery model!

|||thanks a lot ....
if no more affect , I can shrink the log file ...
because I have write another log file program to logging the entry in my program

|||

But if you find you have to shrink the log file again, you have likely missed the point. If the log file is huge, the last thought should be just going and shrinking the log file and be done with the issue. You first need to address your recovery model and backup plan. When you shrink files, you use a lot of expensive disk resource. It also introduces fragmentation at the file, OS level. Shrinking databases or database files should not be something that needs to be done regularly. If you shrink files, and then the grow again, and then you shrink them, you are just going in circles and wasting resources.

-Sue

Please help ~~~

Please help , my company's SQL server database grow so quick , a few day grow 20G, does any tools or server can compress the database ?

Please help me ~~~~

silver
e-mail : silvershi@.gmail.com

Hi Silver,

did you mean the *.mdf File (Datafile) or the *.ldf (Transaction-Logfile)?

|||

try shrink that db

DBCC SHRINKDATABASE ( 'database_name' | database_id | 0 [ ,target_percent ] [ , { NOTRUNCATE | TRUNCATEONLY } ] ) [ WITH NO_INFOMSGS ] if the log growed unexpectedly the command can be BACKUP LOG { database_name | @.database_name_var } WITH { NO_LOG | TRUNCATE_ONLY } [;] this truncate the logAnyway, all depends by many factors as recovery model, the activity on your server, if there is bulk insert of data etc.|||

If I were to guess, you are using full recover model and what is growing is probably your transaction log. The way to deal with that is to backup your transaction log. If you aren't in production, don't need point in time recovery and can afford to lose data, you may want to explore simple recovery model.

That's the simple answer if that is your configuration. A lot of other issues come into play in deciding your recovery model, frequency of backups, etc.

-Sue

|||I means the *.ldf( Transaction-LogFile)

what's can I do ? nowaday the transaction-LogFile is 120G , it so large my sql server just have 60G free now ....
|||thanks for all , I have find a doc. to do this .....

http://support.microsoft.com/?scid=kb%3Ben-us%3B272318&x=10&y=8

thank for your help ~~



|||

This is a very common prob in SQL Server. The growth of Transaction Log(TL) is depends on couple of things... (a) the Recovery Model (b) TL Backup freqency.

(a) first check whether you need Full recovery model , if not change it to Simple

(b) WHat is the Backup policy. if you are taking the TL backup then increase the frequency of the TL backup

(c) If you want to shrink the file then you will have to truncate and shrink it. After truncating and shrinking the first step should be a full backup. otherwise the backup chain will break and u will not be able to restore from TL bakcup.

Refer :

http://support.microsoft.com/kb/873235.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1542414&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1630021&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1623857&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1447193&SiteID=1

Madhu

|||thanks for you help , but I have a question ...
if I shrink the log file , is it have any effect about my data in the database ?

thanks

|||

Hi Sivershi,

normaly no!

But you have to think about Madhu K Nair questions - backup policy, recovery model!

|||thanks a lot ....
if no more affect , I can shrink the log file ...
because I have write another log file program to logging the entry in my program

|||

But if you find you have to shrink the log file again, you have likely missed the point. If the log file is huge, the last thought should be just going and shrinking the log file and be done with the issue. You first need to address your recovery model and backup plan. When you shrink files, you use a lot of expensive disk resource. It also introduces fragmentation at the file, OS level. Shrinking databases or database files should not be something that needs to be done regularly. If you shrink files, and then the grow again, and then you shrink them, you are just going in circles and wasting resources.

-Sue

Monday, March 26, 2012

Please help - Installing reporting services on Windows 2000 professional

I have my developer SQL server on a Windows 2000 professional
workstation company will not let me go for a Windows 2003 server.
I am already running ASP.Net Web Matrix which as it own ASP.Net web
server on my PC please clarify if I can install reporting services on
this web server.
Or if I need IIS please help where can I download IIS6 for WIndows
2000 professional did quite a bit of search cannot find the link.
Thanks
KarenOn 4 Apr 2005 14:44:44 -0700, karenmiddleol@.yahoo.com (Karen
Middleton) wrote:
>I have my developer SQL server on a Windows 2000 professional
>workstation company will not let me go for a Windows 2003 server.
>I am already running ASP.Net Web Matrix which as it own ASP.Net web
>server on my PC please clarify if I can install reporting services on
>this web server.
>Or if I need IIS please help where can I download IIS6 for WIndows
>2000 professional did quite a bit of search cannot find the link.
>Thanks
>Karen
Karen,
Windows 2000 uses IIS 5.0.
It's a while since I used Windows 2000 but I think you can install IIS
5.0 using Add/Remove Programs.
Or simply put the Windows CD in the drive and select the option that
allows you to install additional components.
Andrew Watt
MVP - InfoPath|||By default IIS is not running in 2000 Professional. What you need to do is
go to control panel, add remove programs and then on the left pane (I am
remembering this so exactly how you get to it might be off a little) is
something you select to add remove Windows components. That is where you
install IIS. You will be prompted for your Windows install disk (I believe,
it has been awhile). You will also need to install dotnet 1.1 after you get
IIS installed.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Karen Middleton" <karenmiddleol@.yahoo.com> wrote in message
news:a5fd468a.0504041344.1c1540dc@.posting.google.com...
>I have my developer SQL server on a Windows 2000 professional
> workstation company will not let me go for a Windows 2003 server.
> I am already running ASP.Net Web Matrix which as it own ASP.Net web
> server on my PC please clarify if I can install reporting services on
> this web server.
> Or if I need IIS please help where can I download IIS6 for WIndows
> 2000 professional did quite a bit of search cannot find the link.
> Thanks
> Karen|||Andrew
Thanks for the quick feedback.
Will reporting services work on SQL Developer edition and Windows 2000
Professional if I install IIS 5.
Also, can you please recommend some 3rd party authoring tools that
enable quick authoring of reporting services reports and deploying
them if thru Excel it will be very good.
Thanks
Karen
"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message news:<ude351hpt6vnj5cvf4tmf8scqik66pimbf@.4ax.com>...
> On 4 Apr 2005 14:44:44 -0700, karenmiddleol@.yahoo.com (Karen
> Middleton) wrote:
> >I have my developer SQL server on a Windows 2000 professional
> >workstation company will not let me go for a Windows 2003 server.
> >
> >I am already running ASP.Net Web Matrix which as it own ASP.Net web
> >server on my PC please clarify if I can install reporting services on
> >this web server.
> >
> >Or if I need IIS please help where can I download IIS6 for WIndows
> >2000 professional did quite a bit of search cannot find the link.
> >
> >Thanks
> >Karen
> Karen,
> Windows 2000 uses IIS 5.0.
> It's a while since I used Windows 2000 but I think you can install IIS
> 5.0 using Add/Remove Programs.
> Or simply put the Windows CD in the drive and select the option that
> allows you to install additional components.
> Andrew Watt
> MVP - InfoPath|||This is a great article (this is new since the last time I was on the site).
Definitely worth reading:
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx
As far as the database
http://www.microsoft.com/sql/reporting/productinfo/sysreqs.asp
Note that it says to use the version of database to match the version of RS.
To me that means if you have developer edition of SQL Server that you should
use the same or Reporting Services (i.e. this is good for test and
development only).
MS has a partner page:
http://www.microsoft.com/sql/reporting/partners/default.asp
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Karen Middleton" <karenmiddleol@.yahoo.com> wrote in message
news:a5fd468a.0504041750.300b6c08@.posting.google.com...
> Andrew
> Thanks for the quick feedback.
> Will reporting services work on SQL Developer edition and Windows 2000
> Professional if I install IIS 5.
> Also, can you please recommend some 3rd party authoring tools that
> enable quick authoring of reporting services reports and deploying
> them if thru Excel it will be very good.
> Thanks
> Karen
> "Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
> news:<ude351hpt6vnj5cvf4tmf8scqik66pimbf@.4ax.com>...
>> On 4 Apr 2005 14:44:44 -0700, karenmiddleol@.yahoo.com (Karen
>> Middleton) wrote:
>> >I have my developer SQL server on a Windows 2000 professional
>> >workstation company will not let me go for a Windows 2003 server.
>> >
>> >I am already running ASP.Net Web Matrix which as it own ASP.Net web
>> >server on my PC please clarify if I can install reporting services on
>> >this web server.
>> >
>> >Or if I need IIS please help where can I download IIS6 for WIndows
>> >2000 professional did quite a bit of search cannot find the link.
>> >
>> >Thanks
>> >Karen
>> Karen,
>> Windows 2000 uses IIS 5.0.
>> It's a while since I used Windows 2000 but I think you can install IIS
>> 5.0 using Add/Remove Programs.
>> Or simply put the Windows CD in the drive and select the option that
>> allows you to install additional components.
>> Andrew Watt
>> MVP - InfoPath