impact of changing recovery model on a database that is currently"live"

I'm running sql server 2005 standard edition. We have given up on sql
server replication for various reasons and are gonig to implement
transaction log shipping. I need to switch the database to "Full"
recovery model but owing to a fascinating combination of circumstances
and indecisiveness the server has had replication disabled before the
new backup stratgey is in place. I don't want to wait another day
before I get a replication strategy going to I want to go to FULl
model right NOW. However the databse is in use and I don't want things
to be disrupted. The database server is only lightly loaded (8 cores,
only one running at any one time above 10% and disk queue about 0.1)
and a few seconds of latency is OK..
is it safe to switch recovery model to FULL during working hours on a
production database?
thanks,
sam
sam,
Switching to full mode will not add appreciably to the load on your server,
but it will keep the logs until they are backed up, so you may see grown in
your log (.ldf) files.
When switching to full mode, the first thing to do is a full backup. This
may cause about a 10% hit on the throughput of that server during the time
of the backup. Again, a small price to pay.
Then be sure to schedule regular transaction log backups so that your
transactions are saved and the log files do not grow excessively. (At least
once a day, but depending on your work and its critical nature it could be
as often as every 5 minutes.)
RLF
"sam.m.gardiner" <sam.m.gardiner@.gmail.com> wrote in message
news:6ad20370-72c2-4fec-b623-81e35b63bc9d@.u69g2000hse.googlegroups.com...
> I'm running sql server 2005 standard edition. We have given up on sql
> server replication for various reasons and are gonig to implement
> transaction log shipping. I need to switch the database to "Full"
> recovery model but owing to a fascinating combination of circumstances
> and indecisiveness the server has had replication disabled before the
> new backup stratgey is in place. I don't want to wait another day
> before I get a replication strategy going to I want to go to FULl
> model right NOW. However the databse is in use and I don't want things
> to be disrupted. The database server is only lightly loaded (8 cores,
> only one running at any one time above 10% and disk queue about 0.1)
> and a few seconds of latency is OK..
> is it safe to switch recovery model to FULL during working hours on a
> production database?
> thanks,
> sam
|||ah thanks for that russell, the backup was also a worry.
but i was wondering about the actual moment of switch over, will that
cause any freeze or hang ups?
|||No, basically I understand it does two things.
1. Stops truncating the log
2. Increases the amount of logging done for BULK INSERTs. (If you don't
want this behaviour, the Bulk-Logged recovery model is similar to FULL, but
gives reduced coverage for the bulk inserts.)
RLF
"sam.m.gardiner" <sam.m.gardiner@.gmail.com> wrote in message
news:dde0ef2e-c103-48fd-a5f7-df76652da702@.b1g2000hsg.googlegroups.com...
> ah thanks for that russell, the backup was also a worry.
> but i was wondering about the actual moment of switch over, will that
> cause any freeze or hang ups?
|||thanks for your advice. the switch over was completed with no fuss and
took only a few seconds..
sam
sql

impact of changing recovery model on a database that is currently

I'm running sql server 2005 standard edition. We have given up on sql
server replication for various reasons and are gonig to implement
transaction log shipping. I need to switch the database to "Full"
recovery model but owing to a fascinating combination of circumstances
and indecisiveness the server has had replication disabled before the
new backup stratgey is in place. I don't want to wait another day
before I get a replication strategy going to I want to go to FULl
model right NOW. However the databse is in use and I don't want things
to be disrupted. The database server is only lightly loaded (8 cores,
only one running at any one time above 10% and disk queue about 0.1)
and a few seconds of latency is OK..
is it safe to switch recovery model to FULL during working hours on a
production database?
thanks,
samsam,
Switching to full mode will not add appreciably to the load on your server,
but it will keep the logs until they are backed up, so you may see grown in
your log (.ldf) files.
When switching to full mode, the first thing to do is a full backup. This
may cause about a 10% hit on the throughput of that server during the time
of the backup. Again, a small price to pay.
Then be sure to schedule regular transaction log backups so that your
transactions are saved and the log files do not grow excessively. (At least
once a day, but depending on your work and its critical nature it could be
as often as every 5 minutes.)
RLF
"sam.m.gardiner" <sam.m.gardiner@.gmail.com> wrote in message
news:6ad20370-72c2-4fec-b623-81e35b63bc9d@.u69g2000hse.googlegroups.com...
> I'm running sql server 2005 standard edition. We have given up on sql
> server replication for various reasons and are gonig to implement
> transaction log shipping. I need to switch the database to "Full"
> recovery model but owing to a fascinating combination of circumstances
> and indecisiveness the server has had replication disabled before the
> new backup stratgey is in place. I don't want to wait another day
> before I get a replication strategy going to I want to go to FULl
> model right NOW. However the databse is in use and I don't want things
> to be disrupted. The database server is only lightly loaded (8 cores,
> only one running at any one time above 10% and disk queue about 0.1)
> and a few seconds of latency is OK..
> is it safe to switch recovery model to FULL during working hours on a
> production database?
> thanks,
> sam|||ah thanks for that russell, the backup was also a worry.
but i was wondering about the actual moment of switch over, will that
cause any freeze or hang ups?|||No, basically I understand it does two things.
1. Stops truncating the log
2. Increases the amount of logging done for BULK INSERTs. (If you don't
want this behaviour, the Bulk-Logged recovery model is similar to FULL, but
gives reduced coverage for the bulk inserts.)
RLF
"sam.m.gardiner" <sam.m.gardiner@.gmail.com> wrote in message
news:dde0ef2e-c103-48fd-a5f7-df76652da702@.b1g2000hsg.googlegroups.com...
> ah thanks for that russell, the backup was also a worry.
> but i was wondering about the actual moment of switch over, will that
> cause any freeze or hang ups?|||thanks for your advice. the switch over was completed with no fuss and
took only a few seconds..
sam

IIS Internet Info Services

Hi,

I'm trying to install SQL Server 2005 Enterprise edition.

It is telling me that I don't have IIS installed and that it may

cause some problems. I can't find where to install from

add/remove components nor can I find it in any of my

network connections. Does anyone know where to

install this from? Thanks in advance.

Newbie.......Eric

IIS comes with XP Pro, it is not available with XP Home. It's never installed by default, but you can add it in add windows components.

|||

Yes I did look through the add/remove components section

in the control panel but I don't see it in there anywhere.

Any other ideas would be helpful. I'm on my way the the MS

web-site to see if I can download it somewhere. But yes,

I am running the Home ED.

TIA....Eric

|||

Then, as I said, you're stuck. Home Edition cannot run IIS. That would be a point of differentiation that helps sell the Pro edition.

|||

Yeah that's a bummer.

Well I'm just learning VB all over again.

I did some programming in VB6 for a little while.

So since I'm just learning VB 2005 maybe I won't

that functionality for awhile to come.

Thanks for the help......Eric

|||

If you want to do ASP.NET, I believe VS2005 has a mini web server built into it, but I don't believe that will help if SQL Server thinks it needs it for some reason ( I assume it needs it only to expose itself over the web, which you won't want to do anyhow ).

IIS developer edition

Well, just what the subject line says:
Is there a developer version of IIS one can download?
If so, I can't find it. All I can find are the 180 day trials.

Thanks!
-Gary

Hi Gary, you might want to post this in an IIS forum.

Thanks,
Sam

|||

If you are running anything but Windows XP Home (or 95, 98, ME (the ones we don't talk about anymore)) you should have the option to install IIS from your installation media for free.

What exactly are you looking for in a 'developer edition' that doesn't exist in the regular version that you should already have access to?

|||I am running XP Home.
So I guess I'll just scrounge up some cash and get Pro.
I need the Web Server!

-G

IIS and SQL Server 2005 Express Edition

hi

Currently have SQL Server 2005 Express Edition installed. Wanted to install reporting services, but wouldn't let me re no IIS as I only have Windows XP Home Edition.

My question is therefore: Is there any way of installing IIS to allow me to install Reporting Services for SQL Server 2005 Express Edition

Many thanks

Tim

Leicester, UK

Hi,

actually there is none without breakign the licensing rules.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

I have XP Pro but IIS was not installed at the beginning.

I would want to use Sql Server 2005 Express ( with reporting ).

I never found the way to install IIS. Is There anybody who could tell me how to install IIS ?

I've installed the advanced version of Sql Server 2005 Express. Is there any problem to install IIS after SQL Server ?

Excuse me for my poor English and thank you for advance

Have a nice day

|||

hi to unistall IIS, you have to access the Setitngs, Control Panel Add or Remove Programs, Add or Remove Windows Components.. applet..

regards

|||

I too had a problem running/using reporting services as I didn't have IIS installed on my PC (XP Home edition).

After rebuilding the computer and installing XP Proffessional I installed SQL Express with Avd Services and Toolkit etc but forgot to install the IIS correctly (I think I installed the .net framework before installing IIS). So even after installing IIS my reports would not work.

After all that hassle I started AGAIN with a clean install of XP Proff, installed all the components of IIS, then installed the.net 2.0 framework and then installed SQL Express etc and it worked fine.

Good luck

Garry

|||

Thank you for your clear answer

I see that if you do not install IIS before SQL Server, it's impossible to use reporting services.

All i regreat is that Microsoft nowhere warns about that problem except at the beginning of the installation of SQL Server with a meagre warning.

I hope that Microsoft will correct this absence in the documentation to avoid complete desinstallation/installation of Visual Studio,net 2.0 framework and SQL Server.

Have all a good day

|||

There is no need to start everything from scratch if you have not installed IIS prior to installing SQL Server. There is a need to configure ASP.NET on IIS once you have installed it though because it doesn't happen automatically unless you install the .NET Framework 2.0 after IIS, which you didn't do. Instructions on how to register ASP.NET on IIS can be found here. Once you've registered ASP.NET, you can install Reporting Services by going into Add/Remove Programs, Selecting SQL Server 2005 and using the option to Change an existing installation. The maintenance mode installer will allow you to add Reporting Services to your installation without removing anything else.

As to the wish that we would document this, we do. Durring installation of SQL Server you are warned that IIS is not installed and you have the option of stoping the installation of SQL Server, installing IIS and then starting again.

Mike

IIS & SQL Server 2005 Express Edition installation problems in Vista

Hi,

Im encountering yet another problem in Vista(Vista Home Premium). I have turned on all IIS features from control panel. When I open http://localhost it gives the error

HTTP Error 404.4 - Not Found

Description: The resource you are looking for does not have a handler associated with it

How should i resolve this?

Also, when I try to install SQL server 2005 express edition, it gives the warning that IIS is not installed, though I have installed all the features and it is running.

I have been struggling for the past one week, just to install SQL server on vista!

Please help.

Thanks

Hi,

see this here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1270203&SiteID=1

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Hi, I have gone through the entire thread you pointed me to... but to no avail. I have installed asp.net under IIS without any problems, but im still having the same issues i mentioned earlier. When I open IIS manager, under handler mappings, ISAPI-dll and CGI-exe are disabled by default. Could this be a problem? How do I enable them? please help.

|||Added the defauly http handler for *.htm and *.html extensions in IIS manager. It seems fine now.

Iis & Vs.net

This is a weird question, and I think it might have something to do with my SQL server.
I am running SQL server 2000 Developer Edition on XP pro, and now have been trying to instal VS.Net 2003, yet when I try to install, the installer disk tells me I dont have IIS and FPSE running and configured on my computer... I run through the steps given and IIS still doesn't appear in "Computer Mangaement". The "Inetpub" is on my C: drive, but http://localhost doesnt exist.
I figure it has something to do with my SQL server but I don't know what to do. I need to be able to create Web projects on my computer with VS.NET.
Should I uninstal SQL Server? Do I do this in the registry? Should I instal VS.Net anyway? Do I reformat my hard drive and start from scratch?

Any help will be unbelieveably appreciated, time is short and I'm going nuts.Your PWS (Personal IIS) is not running. Start the service and/or check to see if you have the service installed at all.|||There is no PWS for XP Pro, or rather IIS is the PWS. I followed the simple instructions found everywhere online and on the vs.net CD. Nothing. IIS still doesn't appear under Administrative Tools. I can't figure out why.

*chucks computer out 2nd story window*|||I went and uninstalled it fully and installed it again, I did this like 3 times over the past week, but last night it actually took. huh. If I wasn't so happy it was running I would be pissed that it was so tempermental.

Now all I have to do is create a webservice, and database in time to turn in for my midterm next monday. wish me luck!