MSSQL Server Recovery

Can you give us some indication on the status of your
server i.e. is it accessable.
Can you also give us some indication of your backups and
any replication.
Peter
"It's true hard work never killed anybody, but I figure,
why take the chance?"
Ronald Reagan

>--Original Message--
>Hi,
>The Windows 2000 Server (that has MSSQL Server
installed) is corrupted.
>Can anybody tell me how I can make the existing SQL data
files work in
>another Windows 2000 Server?
>What should I do?
>Thanks & Regards,
>KS
>
>.
>
Hi,
Due to I cannot log into Windows 2000 Server (installed by
ex-administrator),
I need to install a new Windows 2000 Server.
And transfer the existing data files to the new machine.
Regards,
KS
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:136701c48c22$49618100$a501280a@.phx.gbl...[vbcol=seagreen]
> Can you give us some indication on the status of your
> server i.e. is it accessable.
> Can you also give us some indication of your backups and
> any replication.
> Peter
> "It's true hard work never killed anybody, but I figure,
> why take the chance?"
> Ronald Reagan
>
> installed) is corrupted.
> files work in

MSSQL Server Recovery

Can you give us some indication on the status of your
server i.e. is it accessable.
Can you also give us some indication of your backups and
any replication.
Peter
"It's true hard work never killed anybody, but I figure,
why take the chance?"
Ronald Reagan

>--Original Message--
>Hi,
>The Windows 2000 Server (that has MSSQL Server
installed) is corrupted.
>Can anybody tell me how I can make the existing SQL data
files work in
>another Windows 2000 Server?
>What should I do?
>Thanks & Regards,
>KS
>
>.
>Hi,
Due to I cannot log into Windows 2000 Server (installed by
ex-administrator),
I need to install a new Windows 2000 Server.
And transfer the existing data files to the new machine.
Regards,
KS
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:136701c48c22$49618100$a501280a@.phx.gbl...[vbcol=seagreen]
> Can you give us some indication on the status of your
> server i.e. is it accessable.
> Can you also give us some indication of your backups and
> any replication.
> Peter
> "It's true hard work never killed anybody, but I figure,
> why take the chance?"
> Ronald Reagan
>
> installed) is corrupted.
> files work in

MSSQL Server Backups

I would like to modify the amount of backups that the sql server keeps on
record. My reasoning is that I am trying to minimize the size of my full
backups. I was made aware that the server keeps a certain time period of
backups and that I could modify this and lessen the time period that it keeps
backups. I hope this makes sense. Thanks in advance.
hi,
cc.az wrote:
> I would like to modify the amount of backups that the sql server
> keeps on record. My reasoning is that I am trying to minimize the
> size of my full backups. I was made aware that the server keeps a
> certain time period of backups and that I could modify this and
> lessen the time period that it keeps backups. I hope this makes
> sense. Thanks in advance.
all the retaintion for backups can be set manually in the Backup
operation...
you can specify the
RETAINDAYS = 1 -- no of days
or
EXPIREDATE = N'2005/02/03' -- an actual date...
if those 2 settings are not provided, the default expiration is determined
by the media retention configuration setting of sp_configure..
http://msdn.microsoft.com/library/de...ba-bz_35ww.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply