database backup question

For my database backup is there a way to only keep the last 5 backups? Currently my backup is creating a new .bak file with every backup. I only want a .BAK for the last 5 days. So I only want the last 5 .bak files at any given time.
Is there an option to set this or do I need to create a job of sort to delete them manually?
You didn't mention what SQL Server version you use, however you can set up a maintanence plan to delete old files older than ... days.
Ekrem nsoy
"Mike" <Mike@.community.nospam.com> wrote in message news:ufTkFc5JIHA.4584@.TK2MSFTNGP03.phx.gbl...
For my database backup is there a way to only keep the last 5 backups? Currently my backup is creating a new .bak file with every backup. I only want a .BAK for the last 5 days. So I only want the last 5 .bak files at any given time.
Is there an option to set this or do I need to create a job of sort to delete them manually?
|||I'm using SQL 2005.
Where in the maintance plan can I set that?
"Ekrem nsoy" <ekrem@.btegitim.com> wrote in message news:563B7A98-DAA7-4015-818D-7840A3B55015@.microsoft.com...
You didn't mention what SQL Server version you use, however you can set up a maintanence plan to delete old files older than ... days.
Ekrem nsoy
"Mike" <Mike@.community.nospam.com> wrote in message news:ufTkFc5JIHA.4584@.TK2MSFTNGP03.phx.gbl...
For my database backup is there a way to only keep the last 5 backups? Currently my backup is creating a new .bak file with every backup. I only want a .BAK for the last 5 days. So I only want the last 5 .bak files at any given time.
Is there an option to set this or do I need to create a job of sort to delete them manually?
|||the 'maintenance cleanup task' wants an actual folder to 'clean' all of my
..bak files are in sub folders for each db, how will that work, or do i have
to create a clean up plan for each DB?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uP97Nz5JIHA.3940@.TK2MSFTNGP05.phx.gbl...
> In the "maintenance cleanup task".
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Mike" <Mike@.community.nospam.com> wrote in message
> news:Oh5D$w5JIHA.5116@.TK2MSFTNGP03.phx.gbl...
> I'm using SQL 2005.
> Where in the maintance plan can I set that?
> "Ekrem nsoy" <ekrem@.btegitim.com> wrote in message
> news:563B7A98-DAA7-4015-818D-7840A3B55015@.microsoft.com...
> You didn't mention what SQL Server version you use, however you can set
> up a maintanence plan to delete old files older than ... days.
> --
> Ekrem nsoy
>
> "Mike" <Mike@.community.nospam.com> wrote in message
> news:ufTkFc5JIHA.4584@.TK2MSFTNGP03.phx.gbl...
> For my database backup is there a way to only keep the last 5 backups?
> Currently my backup is creating a new .bak file with every backup. I only
> want a .BAK for the last 5 days. So I only want the last 5 .bak files at
> any given time.
> Is there an option to set this or do I need to create a job of sort to
> delete them manually?
>
|||I figured it out. thanks
"Mike" <Mike@.community.nospam.com> wrote in message
news:%23Wi18W6JIHA.3356@.TK2MSFTNGP02.phx.gbl...
> the 'maintenance cleanup task' wants an actual folder to 'clean' all of my
> .bak files are in sub folders for each db, how will that work, or do i
> have to create a clean up plan for each DB?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in message news:uP97Nz5JIHA.3940@.TK2MSFTNGP05.phx.gbl...
>
|||The idea is, you'd have a Backup folder and you'd store your *.bak files in
that specific folder. When you set up a Cleanup Task, you'll point to that
folder and the Task will determine the old files (according to your setting)
and delete them. Also, you can check that sub folder option if there is a
granular backup folder hierarchy. So you'll not have to set up different
Cleanup Tasks for each db you backup under Backup folder.
Ekrem nsoy
"Mike" <Mike@.community.nospam.com> wrote in message
news:%23Wi18W6JIHA.3356@.TK2MSFTNGP02.phx.gbl...
> the 'maintenance cleanup task' wants an actual folder to 'clean' all of my
> .bak files are in sub folders for each db, how will that work, or do i
> have to create a clean up plan for each DB?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in message news:uP97Nz5JIHA.3940@.TK2MSFTNGP05.phx.gbl...
>

database backup question

For my database backup is there a way to only keep the last 5 backups? Curre
ntly my backup is creating a new .bak file with every backup. I only want a
.BAK for the last 5 days. So I only want the last 5 .bak files at any given
time.
Is there an option to set this or do I need to create a job of sort to delet
e them manually?You didn't mention what SQL Server version you use, however you can set up a
maintanence plan to delete old files older than ... days.
--
Ekrem nsoy
"Mike" <Mike@.community.nospam.com> wrote in message news:ufTkFc5JIHA.4584@.TK
2MSFTNGP03.phx.gbl...
For my database backup is there a way to only keep the last 5 backups? Curre
ntly my backup is creating a new .bak file with every backup. I only want a
.BAK for the last 5 days. So I only want the last 5 .bak files at any given
time.
Is there an option to set this or do I need to create a job of sort to delet
e them manually?|||I'm using SQL 2005.
Where in the maintance plan can I set that?
"Ekrem nsoy" <ekrem@.btegitim.com> wrote in message news:563B7A98-DAA7-4015-
818D-7840A3B55015@.microsoft.com...
You didn't mention what SQL Server version you use, however you can set up a
maintanence plan to delete old files older than ... days.
--
Ekrem nsoy
"Mike" <Mike@.community.nospam.com> wrote in message news:ufTkFc5JIHA.4584@.TK
2MSFTNGP03.phx.gbl...
For my database backup is there a way to only keep the last 5 backups? Curre
ntly my backup is creating a new .bak file with every backup. I only want a
.BAK for the last 5 days. So I only want the last 5 .bak files at any given
time.
Is there an option to set this or do I need to create a job of sort to delet
e them manually?|||In the "maintenance cleanup task".
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Mike" <Mike@.community.nospam.com> wrote in message news:Oh5D$w5JIHA.5116@.TK
2MSFTNGP03.phx.gbl...
I'm using SQL 2005.
Where in the maintance plan can I set that?
"Ekrem nsoy" <ekrem@.btegitim.com> wrote in message
news:563B7A98-DAA7-4015-818D-7840A3B55015@.microsoft.com...
You didn't mention what SQL Server version you use, however you can set up a
maintanence plan to
delete old files older than ... days.
Ekrem nsoy
"Mike" <Mike@.community.nospam.com> wrote in message
news:ufTkFc5JIHA.4584@.TK2MSFTNGP03.phx.gbl...
For my database backup is there a way to only keep the last 5 backups? Curre
ntly my backup is
creating a new .bak file with every backup. I only want a .BAK for the last
5 days. So I only want
the last 5 .bak files at any given time.
Is there an option to set this or do I need to create a job of sort to delet
e them manually?|||the 'maintenance cleanup task' wants an actual folder to 'clean' all of my
.bak files are in sub folders for each db, how will that work, or do i have
to create a clean up plan for each DB?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uP97Nz5JIHA.3940@.TK2MSFTNGP05.phx.gbl...
> In the "maintenance cleanup task".
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Mike" <Mike@.community.nospam.com> wrote in message
> news:Oh5D$w5JIHA.5116@.TK2MSFTNGP03.phx.gbl...
> I'm using SQL 2005.
> Where in the maintance plan can I set that?
> "Ekrem nsoy" <ekrem@.btegitim.com> wrote in message
> news:563B7A98-DAA7-4015-818D-7840A3B55015@.microsoft.com...
> You didn't mention what SQL Server version you use, however you can set
> up a maintanence plan to delete old files older than ... days.
> --
> Ekrem nsoy
>
> "Mike" <Mike@.community.nospam.com> wrote in message
> news:ufTkFc5JIHA.4584@.TK2MSFTNGP03.phx.gbl...
> For my database backup is there a way to only keep the last 5 backups?
> Currently my backup is creating a new .bak file with every backup. I only
> want a .BAK for the last 5 days. So I only want the last 5 .bak files at
> any given time.
> Is there an option to set this or do I need to create a job of sort to
> delete them manually?
>|||I figured it out. thanks
"Mike" <Mike@.community.nospam.com> wrote in message
news:%23Wi18W6JIHA.3356@.TK2MSFTNGP02.phx.gbl...
> the 'maintenance cleanup task' wants an actual folder to 'clean' all of my
> .bak files are in sub folders for each db, how will that work, or do i
> have to create a clean up plan for each DB?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in message news:uP97Nz5JIHA.3940@.TK2MSFTNGP05.phx.gbl...
>|||The idea is, you'd have a Backup folder and you'd store your *.bak files in
that specific folder. When you set up a Cleanup Task, you'll point to that
folder and the Task will determine the old files (according to your setting)
and delete them. Also, you can check that sub folder option if there is a
granular backup folder hierarchy. So you'll not have to set up different
Cleanup Tasks for each db you backup under Backup folder.
Ekrem nsoy
"Mike" <Mike@.community.nospam.com> wrote in message
news:%23Wi18W6JIHA.3356@.TK2MSFTNGP02.phx.gbl...
> the 'maintenance cleanup task' wants an actual folder to 'clean' all of my
> .bak files are in sub folders for each db, how will that work, or do i
> have to create a clean up plan for each DB?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in message news:uP97Nz5JIHA.3940@.TK2MSFTNGP05.phx.gbl...
>sql

Database backup from ADP application

if it is possible, how would i go about creating routines (storedprocedures?
)
that can be invoked from a microsoft access ADP file that will backup (and
hopefully have the ability to also restore) as SQL Server database?
thanks for any and all help!
benYou would execute the TSQL BACKUP and RESTORE command from your Access appli
cation. As for how you
execute TSQL command from Access, I suggest you ask in the Access group(s).
:-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ben" <ben_1_ AT hotmail DOT com> wrote in message
news:3AC37D13-C777-462C-ABFD-13F82698A070@.microsoft.com...
> if it is possible, how would i go about creating routines (storedprocedure
s?)
> that can be invoked from a microsoft access ADP file that will backup (and
> hopefully have the ability to also restore) as SQL Server database?
> thanks for any and all help!
> ben

Data warehousing - Design

I'm designing data wareouse where I=B4m taking Data from an=20
operational Database, I=B4m creating dimension tables and=20
facta tables, my question is following.
When creating dimension tables I=B4m sometimes taking=20
column from tables in the operational database where=20
there is no indexing, should I create index for the=20
column in the data warehouse ?.
When creating facta tables and dimension tables for=20
Analyser services should I have dimension tables with=20
primary keys, and facta with foreign keys to the=20
dimension tables.
Does somone knows about some good article for designing=20
Data warehouse for Analyser services
Looking forward to hear from you
Regards
J=F3n SveinssonTry these
http://www.microsoft.com/technet/tr...part5/c2061.asp
http://www.ralphkimball.com/html/articles.html
HTH
Ray Higdon MCSE, MCDBA, CCNA
--
"Jn Sveinsson" <jon@.nordural.is> wrote in message
news:035701c3fab5$f1f389c0$a401280a@.phx.gbl...
I'm designing data wareouse where Im taking Data from an
operational Database, Im creating dimension tables and
facta tables, my question is following.
When creating dimension tables Im sometimes taking
column from tables in the operational database where
there is no indexing, should I create index for the
column in the data warehouse ?.
When creating facta tables and dimension tables for
Analyser services should I have dimension tables with
primary keys, and facta with foreign keys to the
dimension tables.
Does somone knows about some good article for designing
Data warehouse for Analyser services
Looking forward to hear from you
Regards
Jn Sveinsson

Data Types

I'm creating a windows .net form that has SQL as the back-end. One of the
controls is a group box with three radio buttons options. What data type
should this column have, so whatever option the user chooses will be saved o
n
the SQL table?
Another one, a YES/NO field, what data type should this column have?
--
TSHi TS,
You can use a numeric field and store 1 or 0.
please let me know if u have any questions.
best Regards,
Chandra
http://chanduas.blogspot.com/
http://www.SQLResource.com/
---
"TS" wrote:

> I'm creating a windows .net form that has SQL as the back-end. One of the
> controls is a group box with three radio buttons options. What data type
> should this column have, so whatever option the user chooses will be saved
on
> the SQL table?
> Another one, a YES/NO field, what data type should this column have?
> --
> TS|||With three radio buttons you either have three or four options - if you allo
w
none of the options to be selected (maybe as an initial state).
E.g.
null - none selected
0 - first selected
1 - second selected
2 - third selected
etc.
I believe TINYINT could cover that. Look it up in Books Online if you
haven't already.
However, a more humanly-readable aproach would be to use more descriptive
values - make use of enumerations in .Net and map them to a table in your
database if appropriate. After all - this is the 21st century. ;)
ML|||On Thu, 27 Oct 2005 08:26:13 -0700, TS wrote:

>I'm creating a windows .net form that has SQL as the back-end. One of the
>controls is a group box with three radio buttons options. What data type
>should this column have, so whatever option the user chooses will be saved
on
>the SQL table?
>Another one, a YES/NO field, what data type should this column have?
Hi TS,
You're approaching this from the wrong side.
You should first investigate what data is needed for the application
that you are creating. Identify the dependencies and the business rules,
then normalize the data to at least third normal form and create your
tables.
Once that is done, the next step is to create a GUI that makes it as
easy as possible for the user to enter the required data into the
system. For a column where only a few specific options are legal, a
group box with radio buttons might be fine (but so might a textbox with
dropdown). For a column with only two legal values, a yes/no button
might be appropriate (but a checkbox, a dropdown, or a set of two radio
buttons might do as well).
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)

Data type for "Comments" field?

Hi,

I am using SQL Server 2005 Express. I am creating a table, which will have a comments field. Whats an appropriate data type that should be used for a "comments" field? So far, I have unlimited text and characters can be entered, but that a limitation can be placed.

Thanks

Chirs

Most likely, you will be best served with varchar(max).

Varchar(max) will hold up to 2 GB of data.

Data type

I`m creating a database which will be use to store huge news data. Whatis the perfect data type for the news content, because I`ve tried allthe data types but they can`t store very long news. Thank you very much.
The Text data type will do what you are looking to do.

data transformation

hi,
My problem is I am creating a new database. I need to all the tables
and procedures from
one databse to another database in sql server 2000, both in same
server.
Kalaivanan.Hi,
Create those objects in Model database (Template for new databases). New
database will be created based on the Model database size and contents.
So what ever objects available in model willbe copied to new database
created.
Thanks
Hari
SQL Server MVP
"kalaivanan" <mail2kalai@.gmail.com> wrote in message
news:1156250185.220361.249720@.i3g2000cwc.googlegroups.com...
> hi,
> My problem is I am creating a new database. I need to all the tables
> and procedures from
> one databse to another database in sql server 2000, both in same
> server.
> Kalaivanan.
>|||1) BACKUP/RESTORE
2) DETACH/ATTACH
3)DTS
"kalaivanan" <mail2kalai@.gmail.com> wrote in message
news:1156250185.220361.249720@.i3g2000cwc.googlegroups.com...
> hi,
> My problem is I am creating a new database. I need to all the tables
> and procedures from
> one databse to another database in sql server 2000, both in same
> server.
> Kalaivanan.
>|||Just take a backup and restore it to a database with a different name.
You'll also need to pick different file locations. Check out BACKUP
DATABASE and RESTORE DATABASE in the BOL.
This will also "copy" all other objects in the DB.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"kalaivanan" <mail2kalai@.gmail.com> wrote in message
news:1156250185.220361.249720@.i3g2000cwc.googlegroups.com...
hi,
My problem is I am creating a new database. I need to all the tables
and procedures from
one databse to another database in sql server 2000, both in same
server.
Kalaivanan.|||I am sorry; I mis assume the question. The solution for you is:-
1. Backup the source database [ See Backup Database command in books onl
ine]
2. Restore the database with new name in same server [See Restore Databa
se
<new Dbname> with MOVE options in books online]
Thanks
Hari
SQL Server MVP
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:OOJKNhexGHA.4412@.TK2MSFTNGP05.phx.gbl...
> Hi,
> Create those objects in Model database (Template for new databases). New
> database will be created based on the Model database size and contents.
> So what ever objects available in model willbe copied to new database
> created.
> Thanks
> Hari
> SQL Server MVP
> "kalaivanan" <mail2kalai@.gmail.com> wrote in message
> news:1156250185.220361.249720@.i3g2000cwc.googlegroups.com...
>

data transformation

hi,
My problem is I am creating a new database. I need to all the tables
and procedures from
one databse to another database in sql server 2000, both in same
server.
Kalaivanan.Hi,
Create those objects in Model database (Template for new databases). New
database will be created based on the Model database size and contents.
So what ever objects available in model willbe copied to new database
created.
Thanks
Hari
SQL Server MVP
"kalaivanan" <mail2kalai@.gmail.com> wrote in message
news:1156250185.220361.249720@.i3g2000cwc.googlegroups.com...
> hi,
> My problem is I am creating a new database. I need to all the tables
> and procedures from
> one databse to another database in sql server 2000, both in same
> server.
> Kalaivanan.
>|||1) BACKUP/RESTORE
2) DETACH/ATTACH
3)DTS
"kalaivanan" <mail2kalai@.gmail.com> wrote in message
news:1156250185.220361.249720@.i3g2000cwc.googlegroups.com...
> hi,
> My problem is I am creating a new database. I need to all the tables
> and procedures from
> one databse to another database in sql server 2000, both in same
> server.
> Kalaivanan.
>|||Just take a backup and restore it to a database with a different name.
You'll also need to pick different file locations. Check out BACKUP
DATABASE and RESTORE DATABASE in the BOL.
This will also "copy" all other objects in the DB.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"kalaivanan" <mail2kalai@.gmail.com> wrote in message
news:1156250185.220361.249720@.i3g2000cwc.googlegroups.com...
hi,
My problem is I am creating a new database. I need to all the tables
and procedures from
one databse to another database in sql server 2000, both in same
server.
Kalaivanan.|||I am sorry; I mis assume the question. The solution for you is:-
1. Backup the source database [ See Backup Database command in books online]
2. Restore the database with new name in same server [See Restore Database
<new Dbname> with MOVE options in books online]
Thanks
Hari
SQL Server MVP
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:OOJKNhexGHA.4412@.TK2MSFTNGP05.phx.gbl...
> Hi,
> Create those objects in Model database (Template for new databases). New
> database will be created based on the Model database size and contents.
> So what ever objects available in model willbe copied to new database
> created.
> Thanks
> Hari
> SQL Server MVP
> "kalaivanan" <mail2kalai@.gmail.com> wrote in message
> news:1156250185.220361.249720@.i3g2000cwc.googlegroups.com...
>> hi,
>> My problem is I am creating a new database. I need to all the tables
>> and procedures from
>> one databse to another database in sql server 2000, both in same
>> server.
>> Kalaivanan.
>