Basic question about replication

Hi,
I am a newbie to replication. I recently joined a company where I have a SQL
Server running 2000 SP3 and I see a distribution database and Replication
Monitor in the Enterprise Manager.
On going to Tools->Replication ->Configure Publishing, Subscribers and
Distribution a pop-up window comes up. In this window under the Publishers
tab, the name of the Server comes up as selected. In the subscribers tab an
ODBC data source is selected. However, in the Publications database tab, NO
database name is checked.
I want to delete the distribution database. Can I safely assume that no
replication is taking place, since no database has been selected for
replication? Or is there a way to find out if any replication is taking
place? Thanks in advance.Hi,
I am not sure but you can check this by executing
sp_helpreplicationoption
Shows the types of replication options enabled for a server. This stored
procedure is executed at the Publisher on the publication database. Take help
of books onile also.
Manu
"sharman" wrote:
> Hi,
> I am a newbie to replication. I recently joined a company where I have a SQL
> Server running 2000 SP3 and I see a distribution database and Replication
> Monitor in the Enterprise Manager.
> On going to Tools->Replication ->Configure Publishing, Subscribers and
> Distribution a pop-up window comes up. In this window under the Publishers
> tab, the name of the Server comes up as selected. In the subscribers tab an
> ODBC data source is selected. However, in the Publications database tab, NO
> database name is checked.
> I want to delete the distribution database. Can I safely assume that no
> replication is taking place, since no database has been selected for
> replication? Or is there a way to find out if any replication is taking
> place? Thanks in advance.
>

Basic MSDE Setup Question on Windows Server 2003

Dear Colleagues:
This is such an SQL newbie question its not even funny. To begin with,
please forgive my informality as well as my lack of any specific error
messages, etc.. . I think the questions are academic (the specific error
messages and notes are strewn about my desk at work).
Okay, so here I am, I have a shiny new Windows 2003 Advanced server. So I
want to set up a tiny sharepoint team services site, simple enough. Its the
lightweight version that is
included in the Front Page 2002 CD and pooft, instant sharepoint and badda
bing, you have a small website that small workgroups can use. Please note,
this is not a super confidential eyes only website, so if I had lax MSDE
security, it would not keep me awake at night.
So I download the MSDE from Microsoft and realize that I need to provide a
password for the sa account. A switch after setup.exe.
First, is there a way that I can forego this password, that is to say, that
there is a way for me to install MSDE without a service account password.
I provided the password, the install went great, but now I have issues
associating the sharepoint services site to the MSDE. Obviously, the MSDE
needs to know that sharepoint team services is a good boy.
My problem is that I do not see any configuration options in the small MSDE
engine, so the question here is, other than going to SQL 2000 full blown
where I can tweak things, is how to I tell MSDE that
the team services site, via IIS 6 (running in IIS5 mode) is okay to use it.
Ideally, my goal would be to install MSDE without having to provide a
password, but any advice that could be given would be appreciated.
Thanks,
Roger
If you are trying to "configure" the installation of MSDE you need to get a
copy of the enterprise manager from a SQL 2000 CD or something and you can
then use that to connect to the MSDE database and configure it. MSDE itself
does not come with these tools as it is the "lite" version of SQL, but the
enterprise tools can be used with it to configure it.
Hopefully you have an actual SQL 2000 Server on your network somewhere that
you can use to connect to your MSDE database...
HTH.
"Jolly Student" <jolly@.joy.com> wrote in message
news:ifr1d.8926$G03.2990374@.news4.srv.hcvlny.cv.ne t...
> Dear Colleagues:
> This is such an SQL newbie question its not even funny. To begin with,
> please forgive my informality as well as my lack of any specific error
> messages, etc.. . I think the questions are academic (the specific error
> messages and notes are strewn about my desk at work).
> Okay, so here I am, I have a shiny new Windows 2003 Advanced server. So I
> want to set up a tiny sharepoint team services site, simple enough. Its
the
> lightweight version that is
> included in the Front Page 2002 CD and pooft, instant sharepoint and badda
> bing, you have a small website that small workgroups can use. Please note,
> this is not a super confidential eyes only website, so if I had lax MSDE
> security, it would not keep me awake at night.
> So I download the MSDE from Microsoft and realize that I need to provide a
> password for the sa account. A switch after setup.exe.
> First, is there a way that I can forego this password, that is to say,
that
> there is a way for me to install MSDE without a service account password.
> I provided the password, the install went great, but now I have issues
> associating the sharepoint services site to the MSDE. Obviously, the MSDE
> needs to know that sharepoint team services is a good boy.
> My problem is that I do not see any configuration options in the small
MSDE
> engine, so the question here is, other than going to SQL 2000 full blown
> where I can tweak things, is how to I tell MSDE that
> the team services site, via IIS 6 (running in IIS5 mode) is okay to use
it.
> Ideally, my goal would be to install MSDE without having to provide a
> password, but any advice that could be given would be appreciated.
> Thanks,
> Roger
>

Basic MSDE Setup Question on Windows Server 2003

Dear Colleagues:
This is such an SQL newbie question its not even funny. To begin with,
please forgive my informality as well as my lack of any specific error
messages, etc.. . I think the questions are academic (the specific error
messages and notes are strewn about my desk at work).
Okay, so here I am, I have a shiny new Windows 2003 Advanced server. So I
want to set up a tiny sharepoint team services site, simple enough. Its the
lightweight version that is
included in the Front Page 2002 CD and pooft, instant sharepoint and badda
bing, you have a small website that small workgroups can use. Please note,
this is not a super confidential eyes only website, so if I had lax MSDE
security, it would not keep me awake at night.
So I download the MSDE from Microsoft and realize that I need to provide a
password for the sa account. A switch after setup.exe.
First, is there a way that I can forego this password, that is to say, that
there is a way for me to install MSDE without a service account password.
I provided the password, the install went great, but now I have issues
associating the sharepoint services site to the MSDE. Obviously, the MSDE
needs to know that sharepoint team services is a good boy.
My problem is that I do not see any configuration options in the small MSDE
engine, so the question here is, other than going to SQL 2000 full blown
where I can tweak things, is how to I tell MSDE that
the team services site, via IIS 6 (running in IIS5 mode) is okay to use it.
Ideally, my goal would be to install MSDE without having to provide a
password, but any advice that could be given would be appreciated.
Thanks,
Roger
To my knowledge, there is no way to install MSDE (or the full blown SQL Server, for that matter), without an sa password. It used to be that you could leave it blank, but that is obviously a security risk and that option has been eliminated.
As for your other question, it sounds like what you need to do is grant database access to the system account that your IIS server is running under. To do this, you can use the osql tool.
Go to a command prompt and type:
osql -U sa -S (local)
Note: If you provided an instance name during your installation, you should use (local)\<instance name>
You will be prompted for the password.
Next type the following 2 lines, replacing <account_name> with the name of the windown account that IIS is running under.
sp_grantlogin '<account_name>'
go
At this point, IIS should be able to connect to your MSDE installation. From there, it's hard to say what you might need to do. Presumably you need a database created within the database server. And after that is created you will need to grant database access to the login you created above. You can do that with something like:
sp_grantdbaccess 'Corporate\JeffL', 'Jeff'
GO
sp_addrolemember 'db_owner', 'Jeff'
GO
If you're not familiar with these types of operations, it might be best to install the full-blown SQL Server so that you can use the GUI interface to perform these operations.|||If you are trying to "configure" the installation of MSDE you need to get a
copy of the enterprise manager from a SQL 2000 CD or something and you can
then use that to connect to the MSDE database and configure it. MSDE itself
does not come with these tools as it is the "lite" version of SQL, but the
enterprise tools can be used with it to configure it.
Hopefully you have an actual SQL 2000 Server on your network somewhere that
you can use to connect to your MSDE database...
HTH.
"Jolly Student" <jolly@.joy.com> wrote in message
news:ifr1d.8926$G03.2990374@.news4.srv.hcvlny.cv.ne t...
> Dear Colleagues:
> This is such an SQL newbie question its not even funny. To begin with,
> please forgive my informality as well as my lack of any specific error
> messages, etc.. . I think the questions are academic (the specific error
> messages and notes are strewn about my desk at work).
> Okay, so here I am, I have a shiny new Windows 2003 Advanced server. So I
> want to set up a tiny sharepoint team services site, simple enough. Its
the
> lightweight version that is
> included in the Front Page 2002 CD and pooft, instant sharepoint and badda
> bing, you have a small website that small workgroups can use. Please note,
> this is not a super confidential eyes only website, so if I had lax MSDE
> security, it would not keep me awake at night.
> So I download the MSDE from Microsoft and realize that I need to provide a
> password for the sa account. A switch after setup.exe.
> First, is there a way that I can forego this password, that is to say,
that
> there is a way for me to install MSDE without a service account password.
> I provided the password, the install went great, but now I have issues
> associating the sharepoint services site to the MSDE. Obviously, the MSDE
> needs to know that sharepoint team services is a good boy.
> My problem is that I do not see any configuration options in the small
MSDE
> engine, so the question here is, other than going to SQL 2000 full blown
> where I can tweak things, is how to I tell MSDE that
> the team services site, via IIS 6 (running in IIS5 mode) is okay to use
it.
> Ideally, my goal would be to install MSDE without having to provide a
> password, but any advice that could be given would be appreciated.
> Thanks,
> Roger
>

Basic MSDE Setup Question on Windows Server 2003

Dear Colleagues:
This is such an SQL newbie question its not even funny. To begin with,
please forgive my informality as well as my lack of any specific error
messages, etc.. . I think the questions are academic (the specific error
messages and notes are strewn about my desk at work).
Okay, so here I am, I have a shiny new Windows 2003 Advanced server. So I
want to set up a tiny sharepoint team services site, simple enough. Its the
lightweight version that is
included in the Front Page 2002 CD and pooft, instant sharepoint and badda
bing, you have a small website that small workgroups can use. Please note,
this is not a super confidential eyes only website, so if I had lax MSDE
security, it would not keep me awake at night.
So I download the MSDE from Microsoft and realize that I need to provide a
password for the sa account. A switch after setup.exe.
First, is there a way that I can forego this password, that is to say, that
there is a way for me to install MSDE without a service account password.
I provided the password, the install went great, but now I have issues
associating the sharepoint services site to the MSDE. Obviously, the MSDE
needs to know that sharepoint team services is a good boy.
My problem is that I do not see any configuration options in the small MSDE
engine, so the question here is, other than going to SQL 2000 full blown
where I can tweak things, is how to I tell MSDE that
the team services site, via IIS 6 (running in IIS5 mode) is okay to use it.
Ideally, my goal would be to install MSDE without having to provide a
password, but any advice that could be given would be appreciated.
Thanks,
Roger
If you are trying to "configure" the installation of MSDE you need to get a
copy of the enterprise manager from a SQL 2000 CD or something and you can
then use that to connect to the MSDE database and configure it. MSDE itself
does not come with these tools as it is the "lite" version of SQL, but the
enterprise tools can be used with it to configure it.
Hopefully you have an actual SQL 2000 Server on your network somewhere that
you can use to connect to your MSDE database...
HTH.
"Jolly Student" <jolly@.joy.com> wrote in message
news:ifr1d.8926$G03.2990374@.news4.srv.hcvlny.cv.ne t...
> Dear Colleagues:
> This is such an SQL newbie question its not even funny. To begin with,
> please forgive my informality as well as my lack of any specific error
> messages, etc.. . I think the questions are academic (the specific error
> messages and notes are strewn about my desk at work).
> Okay, so here I am, I have a shiny new Windows 2003 Advanced server. So I
> want to set up a tiny sharepoint team services site, simple enough. Its
the
> lightweight version that is
> included in the Front Page 2002 CD and pooft, instant sharepoint and badda
> bing, you have a small website that small workgroups can use. Please note,
> this is not a super confidential eyes only website, so if I had lax MSDE
> security, it would not keep me awake at night.
> So I download the MSDE from Microsoft and realize that I need to provide a
> password for the sa account. A switch after setup.exe.
> First, is there a way that I can forego this password, that is to say,
that
> there is a way for me to install MSDE without a service account password.
> I provided the password, the install went great, but now I have issues
> associating the sharepoint services site to the MSDE. Obviously, the MSDE
> needs to know that sharepoint team services is a good boy.
> My problem is that I do not see any configuration options in the small
MSDE
> engine, so the question here is, other than going to SQL 2000 full blown
> where I can tweak things, is how to I tell MSDE that
> the team services site, via IIS 6 (running in IIS5 mode) is okay to use
it.
> Ideally, my goal would be to install MSDE without having to provide a
> password, but any advice that could be given would be appreciated.
> Thanks,
> Roger
>
sql

Backup with time expired

hello, i'm newbie at here. Nice to be here. I wanna ask about a query to backup database with time expired. I use SQL Server 7.0, 2000, and 2005. Thanx for response...
You need to provide more information. What do you mean by "with time expired".|||I mean with "time expired" is when you set backup option with overwrite existing media, you also can set a backup expire time.
Like when you set 1 day at the option then it will not backup automatically after 1 day.
|||

Hi,

Are you writing script or using wizard? If you are writing script provide and we will review. If you are using the wizard, it's pretty self explanatory, but the older versions 7 & 2000 don't have expiration, but you can delete files older than 1 day, etc. on the "specify backup disk directory" page. How we do our backups is after the backup is created it deletes previous day's backup. If you cannot afford to lose any data then do differencials frequently (hourly) with logs every 5 minutes. Deleting the differencials every 2 hours and logs every 3 hours. All of our backups are done to disk first and then to tape. Tapes are used for a week, with the weekend being save until the next week, the month-end saved until you have a year-end and year-ends saved infinitely.

Something like that.

Books on line have the scripts: MSSQL 2000

BACKUP

Syntax

Backing up an entire database:

BACKUP DATABASE { database_name | @.database_name_var }
TO < backup_device > [ ,...n ]
[ WITH
[ BLOCKSIZE = { blocksize | @.blocksize_variable } ]
[ [ , ] DESCRIPTION = { 'text' | @.text_variable } ]
[ [ , ] DIFFERENTIAL ]
[ [ , ] EXPIREDATE = { date | @.date_var }
| RETAINDAYS = { days | @.days_var } ]
[ [ , ] PASSWORD = { password | @.password_variable } ]
[ [ , ] FORMAT | NOFORMAT ]
[ [ , ] { INIT | NOINIT } ]
[ [ , ] MEDIADESCRIPTION = { 'text' | @.text_variable } ]
[ [ , ] MEDIANAME = { media_name | @.media_name_variable } ]
[ [ , ] MEDIAPASSWORD = { mediapassword | @.mediapassword_variable } ]
[ [ , ] NAME = { backup_set_name | @.backup_set_name_var } ]
[ [ , ] { NOSKIP | SKIP } ]
[ [ , ] { NOREWIND | REWIND } ]
[ [ , ] { NOUNLOAD | UNLOAD } ]
[ [ , ] RESTART ]
[ [ , ] STATS [ = percentage ] ]
]

In the code you can see EXPIRATIONDATE, RETAINDAYS, all is described in the books on line.