Wednesday, March 21, 2012

last re-cycle of SQL Server

Hi,
Is there anyone know what is the the meaning of last re-cycle of SQL Server
and when does it occur?
Thanks,
KennyI'd take that to mean, "When was the last time SQL Server was started"
To find out you can
SELECT crdate FROM master..sysdatabases where name = 'tempdb'
"Kenny" <keejh@.hotmail.com> wrote in message
news:#GPhIPYAGHA.264@.tk2msftngp13.phx.gbl...
> Hi,
> Is there anyone know what is the the meaning of last re-cycle of SQL
Server
> and when does it occur?
> Thanks,
> Kenny
>|||The only refereces to "recycle" in Books Online refers to the recycling of
SQL Server error log files or recycling backup sets.
There is a process called "recycling" by which Reporting Services or ASP.NET
application domains will periodically forward requests to a new instance of
the application so the original instance can be deleted.
http://msdn2.microsoft.com/en-us/library/ms159206.aspx
"Kenny" <keejh@.hotmail.com> wrote in message
news:%23GPhIPYAGHA.264@.tk2msftngp13.phx.gbl...
> Hi,
> Is there anyone know what is the the meaning of last re-cycle of SQL
> Server and when does it occur?
> Thanks,
> Kenny
>

No comments:

Post a Comment