I can't backup the transaction log for the pubs database
on any systems I have. I even made some bogus transactions
to have something in the log. Is backing up the Pubs T/log
not allowed? Thanks in advance for your reply.--Denhi Den,
Its because recovery model of pubs database must be simple. change it to
bulk-logged/full and then try taking backup.
- Vishal
Showing posts with label pubs. Show all posts
Showing posts with label pubs. Show all posts
Friday, March 9, 2012
Pubs Transaction log
I can't backup the transaction log for the pubs database
on any systems I have. I even made some bogus transactions
to have something in the log. Is backing up the Pubs T/log
not allowed? Thanks in advance for your reply.--Denhi Den,
Its because recovery model of pubs database must be simple. change it to
bulk-logged/full and then try taking backup.
--
- Vishal
on any systems I have. I even made some bogus transactions
to have something in the log. Is backing up the Pubs T/log
not allowed? Thanks in advance for your reply.--Denhi Den,
Its because recovery model of pubs database must be simple. change it to
bulk-logged/full and then try taking backup.
--
- Vishal
Pubs not installed?
Both myself and my tech editor do not have the Pubs database installed as part of SQL Express 2005 in VS 2005 Team System Beta 2 and VB 2005 professional Beta 2. Is it 1) deliberately left out, 2) just missing in Beta 2 and will be in RC1 or 3) we did dsomwthing wrong and it should be there.
Thanks!
S
The SQL Server Express SKU does not include Books Online or the sample databases. Books Online will be available as a separate download. In the meantime you can download one of the other editions (developer/beta, standard, etc) and install Books Online from that edition.Dan|||Yes, but what about the pubs database?
pubs in Desktop Version of SQL2ksp3
I'm using VS and I've been trying to do the examples on
the tutorial. As topic title suggested, I'm using a
desktop version of the SQL2k service pack 3. However, I
can't seem to make a connection to the pubs database. The
only database I get are master, model, msdb and tempdb.
What exactly should I do to get this working?
Thanks in advance. ^_^
hi,
<anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:95e001c4338b$ba009e90$a501280a@.phx.gbl...
> I'm using VS and I've been trying to do the examples on
> the tutorial. As topic title suggested, I'm using a
> desktop version of the SQL2k service pack 3. However, I
> can't seem to make a connection to the pubs database. The
> only database I get are master, model, msdb and tempdb.
> What exactly should I do to get this working?
> Thanks in advance. ^_^
Pubs and Northwind sample databases are not present in the MSDE packages, in
order to limit thery deployment size...
you can actually get the database package at
http://www.microsoft.com/downloads/d...DisplayLang=en
hth
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
the tutorial. As topic title suggested, I'm using a
desktop version of the SQL2k service pack 3. However, I
can't seem to make a connection to the pubs database. The
only database I get are master, model, msdb and tempdb.
What exactly should I do to get this working?
Thanks in advance. ^_^
hi,
<anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:95e001c4338b$ba009e90$a501280a@.phx.gbl...
> I'm using VS and I've been trying to do the examples on
> the tutorial. As topic title suggested, I'm using a
> desktop version of the SQL2k service pack 3. However, I
> can't seem to make a connection to the pubs database. The
> only database I get are master, model, msdb and tempdb.
> What exactly should I do to get this working?
> Thanks in advance. ^_^
Pubs and Northwind sample databases are not present in the MSDE packages, in
order to limit thery deployment size...
you can actually get the database package at
http://www.microsoft.com/downloads/d...DisplayLang=en
hth
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Pubs database for MSDE
I installed MSDE2000 on my Win XP Pro computer to run
through examples in a book. Some of the examples uses the
Pubs database which I cannot find in my MSDE setup. How
can I setup the Pubs database in my setup and where can I
download it from? Thanks.
We have just made a file available in the Microsoft Download Center that
contains scripts for creating the pubs and Northwind sample databases.
Go to http://www.microsoft.com/downloads
Select SQL Server as the Product and enter sample databases in the Keywords
field and click Go. You will see an entry for Sample Databases.
The direct link is:
http://www.microsoft.com/downloads/d...DisplayLang=en
From the download file readme:
These copies of the scripts are the same as the versions included with SQL
Server 2000, except for these changes:
a.. The script for creating pubs, instpubs.sql, has been modified to
install pubs and all of the pubs data in one step. The version of
instpubs.sql included in SQL Server 2000 does not load in some of the pubs
data, customers had to run batch jobs to install some of the larger data
values.
b.. The scripts improve security by not creating a guest account and not
assigning permissions to the objects in the sample databases. Customers who
install the sample databases can now control access to the sample databases.
SQL Server 2000 Desktop Engine (MSDE 2000) customers can also use these
copies of the scripts to install pubs and Northwind.
Alan Brewer [MSFT]
Lead Programming Writer
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
through examples in a book. Some of the examples uses the
Pubs database which I cannot find in my MSDE setup. How
can I setup the Pubs database in my setup and where can I
download it from? Thanks.
We have just made a file available in the Microsoft Download Center that
contains scripts for creating the pubs and Northwind sample databases.
Go to http://www.microsoft.com/downloads
Select SQL Server as the Product and enter sample databases in the Keywords
field and click Go. You will see an entry for Sample Databases.
The direct link is:
http://www.microsoft.com/downloads/d...DisplayLang=en
From the download file readme:
These copies of the scripts are the same as the versions included with SQL
Server 2000, except for these changes:
a.. The script for creating pubs, instpubs.sql, has been modified to
install pubs and all of the pubs data in one step. The version of
instpubs.sql included in SQL Server 2000 does not load in some of the pubs
data, customers had to run batch jobs to install some of the larger data
values.
b.. The scripts improve security by not creating a guest account and not
assigning permissions to the objects in the sample databases. Customers who
install the sample databases can now control access to the sample databases.
SQL Server 2000 Desktop Engine (MSDE 2000) customers can also use these
copies of the scripts to install pubs and Northwind.
Alan Brewer [MSFT]
Lead Programming Writer
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Pubs and Northwind
I have MSDE 2000 installed but don't know how to connect to pubs or
northwind. Could anyone help? Running Svr 03
The sample databases do not come with the MSDE distribution. But, you can
download them from:
http://www.microsoft.com/sql/msde/downloads/default.asp
Jim
"glennTK" <glenntk@.gtkcomputer.com> wrote in message
news:%231NmrNSGFHA.3648@.TK2MSFTNGP09.phx.gbl...
>I have MSDE 2000 installed but don't know how to connect to pubs or
> northwind. Could anyone help? Running Svr 03
>
northwind. Could anyone help? Running Svr 03
The sample databases do not come with the MSDE distribution. But, you can
download them from:
http://www.microsoft.com/sql/msde/downloads/default.asp
Jim
"glennTK" <glenntk@.gtkcomputer.com> wrote in message
news:%231NmrNSGFHA.3648@.TK2MSFTNGP09.phx.gbl...
>I have MSDE 2000 installed but don't know how to connect to pubs or
> northwind. Could anyone help? Running Svr 03
>
Subscribe to:
Posts (Atom)