how to remove sharepoint database and service

I'm trying to install doubletake, but it is complaining about SHAREPoint,
unable to connect, etc. That isn't the database I want to connect to anyway.
Is it possible to remove it and also remove the service for it? I tried to
export it and then delete it, but doubletake continue asking me if I wanted
to start it, probably because the service was still there. Anyway, I'm
looking to clean SHAREPOINT out completely.
I'm using SQL 2005 Express. I don't remember setting up that database nor
do I know where it came from.
Thanks,
I'm also getting this error if this helps? SQL Server blocked access to
procedure 'dbo.sp_get_sqlagent_properties' of component 'Agent XPs' because
this component is turned off as part of the security configuration for this
server. A system administrator can enable the use of 'Agent XPs' by using
sp_configure. For more information about enabling 'Agent XPs', see "Surface
Area Configuration" in SQL Server Books Online.
"Jeff Viola" wrote:

> I'm trying to install doubletake, but it is complaining about SHAREPoint,
> unable to connect, etc. That isn't the database I want to connect to anyway.
> Is it possible to remove it and also remove the service for it? I tried to
> export it and then delete it, but doubletake continue asking me if I wanted
> to start it, probably because the service was still there. Anyway, I'm
> looking to clean SHAREPOINT out completely.
> I'm using SQL 2005 Express. I don't remember setting up that database nor
> do I know where it came from.
> Thanks,

how to remove sharepoint database and service

I'm trying to install doubletake, but it is complaining about SHAREPoint,
unable to connect, etc. That isn't the database I want to connect to anyway
.
Is it possible to remove it and also remove the service for it? I tried to
export it and then delete it, but doubletake continue asking me if I wanted
to start it, probably because the service was still there. Anyway, I'm
looking to clean SHAREPOINT out completely.
I'm using SQL 2005 Express. I don't remember setting up that database nor
do I know where it came from.
Thanks,I'm also getting this error if this helps? SQL Server blocked access to
procedure 'dbo.sp_get_sqlagent_properties' of component 'Agent XPs' because
this component is turned off as part of the security configuration for this
server. A system administrator can enable the use of 'Agent XPs' by using
sp_configure. For more information about enabling 'Agent XPs', see "Surface
Area Configuration" in SQL Server Books Online.
"Jeff Viola" wrote:

> I'm trying to install doubletake, but it is complaining about SHAREPoint,
> unable to connect, etc. That isn't the database I want to connect to anyw
ay.
> Is it possible to remove it and also remove the service for it? I tried
to
> export it and then delete it, but doubletake continue asking me if I wante
d
> to start it, probably because the service was still there. Anyway, I'm
> looking to clean SHAREPOINT out completely.
> I'm using SQL 2005 Express. I don't remember setting up that database nor
> do I know where it came from.
> Thanks,

How to remove all non-system service broker objects

I'm looking for a tool or script that can wipe a database clean of any and all user configured service broker objects.

I've got two environments, Development and QA, that I need to have parallel service broker configurations. Each environment is hosted on a different set of servers. I need to make sure the Development environment looks exactly like the QA environment from a Service Broker perspective (other than the specific service broker instance references in the installed routes). I've got a script to build the objects that I want, but the Development environment is full of artifacts of abandoned experiments. Before running the creation script in Development, I'd like to start with a clean slate. Recreating the Development databases is not an option.

If a tool or script is not available, I know I need to adress at least the following object types, but I'm not sure if this list covers everything or in which order I need to drop which objects: routes, remote service bindings, certificates, database principals, tcp endpoints, services, queues, contracts, and message types

Thanks in advance

Lee

I would suggest to create a script that drops all types of objects (services, contracts, message types, queues, routes, remote service bindings). One easy criteria to choose wheter is a 'system' object or not is to look if a similar object (same type and name) exists in [master]. If it does, then is 'system'. Each of these types has a coresponding metadata view: sys.services, sys.service_contracts, sys.service_message_types, sys.service_queues, sys.routes, sys.re:mote_service_bindings.

Attempting to drop a true 'system' object would fail. But there is one object that is implicitly created, but is not trully system: the 'AutoCreatedLocal' route in each database. this route can be altered and dropped, it is not a system object.

HTH,
~ Remus

How to release the memory allocated to SQL Server?

The task manager shows my SQL Server use 1.7G memory. However, it returns
130M if I stop and start the service and it will keep this amount quite a
while. Anyway to "release" the memory without stop the server?
> The task manager shows my SQL Server use 1.7G memory. However, it returns
> 130M if I stop and start the service and it will keep this amount quite a
> while. Anyway to "release" the memory without stop the server?
Set server option "max memory".
INF: SQL Server Memory Usage
http://www.support.microsoft.com/?id=321363
AMB
"nick" wrote:

> The task manager shows my SQL Server use 1.7G memory. However, it returns
> 130M if I stop and start the service and it will keep this amount quite a
> while. Anyway to "release" the memory without stop the server?
|||You can set the Max memory option so that sql server won't take more than
that memory...normally sql server release the memory if other processes
requires more memory...do u have any particular reason to reduce the sql
server memory usage?
"nick" wrote:

> The task manager shows my SQL Server use 1.7G memory. However, it returns
> 130M if I stop and start the service and it will keep this amount quite a
> while. Anyway to "release" the memory without stop the server?
|||SQL Server does not release memory unless the OS asks for it. This is the
intended behavior.
http://www.support.microsoft.com/?id=321363 SQL Server 7 & 2000 memory
usage
Andrew J. Kelly SQL MVP
"nick" <nick@.discussions.microsoft.com> wrote in message
news:6251FBB2-9DCE-4990-A03E-54A0197B7E06@.microsoft.com...
> The task manager shows my SQL Server use 1.7G memory. However, it returns
> 130M if I stop and start the service and it will keep this amount quite a
> while. Anyway to "release" the memory without stop the server?
|||I am running Analysis Service at the same machine. However, it looks the AS
has problem if SQL Server already takes a lot of memory and SQL Server
doesn't release memory when AS keep allocating more and more memory and
finally behave strange.
"harvinder" wrote:
[vbcol=seagreen]
> You can set the Max memory option so that sql server won't take more than
> that memory...normally sql server release the memory if other processes
> requires more memory...do u have any particular reason to reduce the sql
> server memory usage?
> "nick" wrote:
|||I am running Analysis Service at the same machine. However, it looks the AS
has problem if SQL Server already takes a lot of memory and SQL Server
doesn't release memory when AS keep allocating more and more memory and
finally behave strange.
"harvinder" wrote:
[vbcol=seagreen]
> You can set the Max memory option so that sql server won't take more than
> that memory...normally sql server release the memory if other processes
> requires more memory...do u have any particular reason to reduce the sql
> server memory usage?
> "nick" wrote:

How to release the memory allocated to SQL Server?

The task manager shows my SQL Server use 1.7G memory. However, it returns
130M if I stop and start the service and it will keep this amount quite a
while. Anyway to "release" the memory without stop the server?> The task manager shows my SQL Server use 1.7G memory. However, it returns
> 130M if I stop and start the service and it will keep this amount quite a
> while. Anyway to "release" the memory without stop the server?
Set server option "max memory".
INF: SQL Server Memory Usage
http://www.support.microsoft.com/?id=321363
AMB
"nick" wrote:

> The task manager shows my SQL Server use 1.7G memory. However, it returns
> 130M if I stop and start the service and it will keep this amount quite a
> while. Anyway to "release" the memory without stop the server?|||You can set the Max memory option so that sql server won't take more than
that memory...normally sql server release the memory if other processes
requires more memory...do u have any particular reason to reduce the sql
server memory usage?
"nick" wrote:

> The task manager shows my SQL Server use 1.7G memory. However, it returns
> 130M if I stop and start the service and it will keep this amount quite a
> while. Anyway to "release" the memory without stop the server?|||SQL Server does not release memory unless the OS asks for it. This is the
intended behavior.
http://www.support.microsoft.com/?id=321363 SQL Server 7 & 2000 memory
usage
Andrew J. Kelly SQL MVP
"nick" <nick@.discussions.microsoft.com> wrote in message
news:6251FBB2-9DCE-4990-A03E-54A0197B7E06@.microsoft.com...
> The task manager shows my SQL Server use 1.7G memory. However, it returns
> 130M if I stop and start the service and it will keep this amount quite a
> while. Anyway to "release" the memory without stop the server?|||I am running Analysis Service at the same machine. However, it looks the AS
has problem if SQL Server already takes a lot of memory and SQL Server
doesn't release memory when AS keep allocating more and more memory and
finally behave strange.
"harvinder" wrote:
[vbcol=seagreen]
> You can set the Max memory option so that sql server won't take more than
> that memory...normally sql server release the memory if other processes
> requires more memory...do u have any particular reason to reduce the sql
> server memory usage?
> "nick" wrote:
>|||I am running Analysis Service at the same machine. However, it looks the AS
has problem if SQL Server already takes a lot of memory and SQL Server
doesn't release memory when AS keep allocating more and more memory and
finally behave strange.
"harvinder" wrote:
[vbcol=seagreen]
> You can set the Max memory option so that sql server won't take more than
> that memory...normally sql server release the memory if other processes
> requires more memory...do u have any particular reason to reduce the sql
> server memory usage?
> "nick" wrote:
>sql

How to release the memory allocated to SQL Server?

The task manager shows my SQL Server use 1.7G memory. However, it returns
130M if I stop and start the service and it will keep this amount quite a
while. Anyway to "release" the memory without stop the server?> The task manager shows my SQL Server use 1.7G memory. However, it returns
> 130M if I stop and start the service and it will keep this amount quite a
> while. Anyway to "release" the memory without stop the server?
Set server option "max memory".
INF: SQL Server Memory Usage
http://www.support.microsoft.com/?id=321363
AMB
"nick" wrote:
> The task manager shows my SQL Server use 1.7G memory. However, it returns
> 130M if I stop and start the service and it will keep this amount quite a
> while. Anyway to "release" the memory without stop the server?|||You can set the Max memory option so that sql server won't take more than
that memory...normally sql server release the memory if other processes
requires more memory...do u have any particular reason to reduce the sql
server memory usage?
"nick" wrote:
> The task manager shows my SQL Server use 1.7G memory. However, it returns
> 130M if I stop and start the service and it will keep this amount quite a
> while. Anyway to "release" the memory without stop the server?|||SQL Server does not release memory unless the OS asks for it. This is the
intended behavior.
http://www.support.microsoft.com/?id=321363 SQL Server 7 & 2000 memory
usage
--
Andrew J. Kelly SQL MVP
"nick" <nick@.discussions.microsoft.com> wrote in message
news:6251FBB2-9DCE-4990-A03E-54A0197B7E06@.microsoft.com...
> The task manager shows my SQL Server use 1.7G memory. However, it returns
> 130M if I stop and start the service and it will keep this amount quite a
> while. Anyway to "release" the memory without stop the server?|||I am running Analysis Service at the same machine. However, it looks the AS
has problem if SQL Server already takes a lot of memory and SQL Server
doesn't release memory when AS keep allocating more and more memory and
finally behave strange.
"harvinder" wrote:
> You can set the Max memory option so that sql server won't take more than
> that memory...normally sql server release the memory if other processes
> requires more memory...do u have any particular reason to reduce the sql
> server memory usage?
> "nick" wrote:
> > The task manager shows my SQL Server use 1.7G memory. However, it returns
> > 130M if I stop and start the service and it will keep this amount quite a
> > while. Anyway to "release" the memory without stop the server?|||I am running Analysis Service at the same machine. However, it looks the AS
has problem if SQL Server already takes a lot of memory and SQL Server
doesn't release memory when AS keep allocating more and more memory and
finally behave strange.
"harvinder" wrote:
> You can set the Max memory option so that sql server won't take more than
> that memory...normally sql server release the memory if other processes
> requires more memory...do u have any particular reason to reduce the sql
> server memory usage?
> "nick" wrote:
> > The task manager shows my SQL Server use 1.7G memory. However, it returns
> > 130M if I stop and start the service and it will keep this amount quite a
> > while. Anyway to "release" the memory without stop the server?

How to Re-Install Reporting Services in SQL 2005?

I have removed Reporting Service from SQL2005.
Now, I want to install it again.
The setup does not give me this option.
What should I do to re-install reporting services again?
Thank youOn Mar 5, 12:41 pm, "leoh" <leonardomach...@.gmail.com> wrote:
> I have removed Reporting Service from SQL2005.
> Now, I want to install it again.
> The setup does not give me this option.
> What should I do to re-install reporting services again?
> Thank you
It sounds kind of like you were not able to completely uninstall SSRS.
I believe that there is a Microsoft utility that should be able to
remove the remanants of the original SSRS; however, I don't remember
the name of it. Sorry, I wish I could help you further.
Regards,
Enrique Martinez
Sr. SQL Server Developer

how to recover deleted reports

I accidentally deleted few reports from reporting service management site.
how can i recover them? Thank you.Unless you have a backup you can't (of reporting services database). You
would need to redeploy these reports.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"showjohnathan" <showjohnathan@.discussions.microsoft.com> wrote in message
news:07A380C6-5AF2-430E-A04D-F4A13B5249C5@.microsoft.com...
>I accidentally deleted few reports from reporting service management site.
> how can i recover them? Thank you.|||thanks
"Bruce L-C [MVP]" wrote:
> Unless you have a backup you can't (of reporting services database). You
> would need to redeploy these reports.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "showjohnathan" <showjohnathan@.discussions.microsoft.com> wrote in message
> news:07A380C6-5AF2-430E-A04D-F4A13B5249C5@.microsoft.com...
> >I accidentally deleted few reports from reporting service management site.
> > how can i recover them? Thank you.
>
>