New to SQL 2005 and backing up databases

I have just started working in SQL 2005 and was wondering what the easiest or
standard way is to backup the databases on the SQL Server.
Thanks...Mike

You can right-click on the Database in SQL Server Management Studio (SSMS) and
then select Tasks -> Backup.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"MikeP125" wrote in message
news:4705DE4A-0B1F-4346-AFCD-A7D928CD136A-at-microsoft.com...
I have just started working in SQL 2005 and was wondering what the easiest
or
standard way is to backup the databases on the SQL Server.
Thanks...Mike

See Books Online and the BACKUP DATABASE and BACKUP LOG commands to write
your own (not that difficult). Or right-click on a database name in the
object browser in SQL Server Management Studio and select Tasks..Backup. or
set up a maintenance plan (which has a wizard to help you). This is in the
Management folder in SSMS.

--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net


"MikeP125" wrote in message
news:4705DE4A-0B1F-4346-AFCD-A7D928CD136A-at-microsoft.com...
>I have just started working in SQL 2005 and was wondering what the easiest
>or
> standard way is to backup the databases on the SQL Server.
> Thanks...Mike

That Maintenance Plan feature ROCKS!! Thanks, that was easy and PAINLESS!

"TheSQLGuru" wrote:

> See Books Online and the BACKUP DATABASE and BACKUP LOG commands to write
> your own (not that difficult). Or right-click on a database name in the
> object browser in SQL Server Management Studio and select Tasks..Backup. or
> set up a maintenance plan (which has a wizard to help you). This is in the
> Management folder in SSMS.
>
> --
> Kevin G. Boles
> Indicium Resources, Inc.
> SQL Server MVP
> kgboles a earthlink dt net
>
>
> "MikeP125" wrote in message
> news:4705DE4A-0B1F-4346-AFCD-A7D928CD136A-at-microsoft.com...
> >I have just started working in SQL 2005 and was wondering what the easiest
> >or
> > standard way is to backup the databases on the SQL Server.
> > Thanks...Mike
>
>
>

Well, for any databases that are in FULL recovery mode, make sure you backup
the transaction logs at least occasionally. Otherwise you will be back here
in a few weeks or months asking why your tlogs have filled up the drive.
:-)

--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net


"MikeP125" wrote in message
news:71FD0587-71AB-4317-BAD0-D744C06683B3-at-microsoft.com...
> That Maintenance Plan feature ROCKS!! Thanks, that was easy and PAINLESS!
>
> "TheSQLGuru" wrote:
>
>> See Books Online and the BACKUP DATABASE and BACKUP LOG commands to write
>> your own (not that difficult). Or right-click on a database name in the
>> object browser in SQL Server Management Studio and select Tasks..Backup.
>> or
>> set up a maintenance plan (which has a wizard to help you). This is in
>> the
>> Management folder in SSMS.
>>
>> --
>> Kevin G. Boles
>> Indicium Resources, Inc.
>> SQL Server MVP
>> kgboles a earthlink dt net
>>
>>
>> "MikeP125" wrote in message
>> news:4705DE4A-0B1F-4346-AFCD-A7D928CD136A-at-microsoft.com...
>> >I have just started working in SQL 2005 and was wondering what the
>> >easiest
>> >or
>> > standard way is to backup the databases on the SQL Server.
>> > Thanks...Mike
>>
>>
>>

You were right, my TLogs are filling up the drive. What is the best way to
back them up and purge them? A regular copy and paste? Can I delete the
TLogs? What do the TLogs do for me?

"TheSQLGuru" wrote:

> Well, for any databases that are in FULL recovery mode, make sure you backup
> the transaction logs at least occasionally. Otherwise you will be back here
> in a few weeks or months asking why your tlogs have filled up the drive.
> :-)
>
> --
> Kevin G. Boles
> Indicium Resources, Inc.
> SQL Server MVP
> kgboles a earthlink dt net
>
>
> "MikeP125" wrote in message
> news:71FD0587-71AB-4317-BAD0-D744C06683B3-at-microsoft.com...
> > That Maintenance Plan feature ROCKS!! Thanks, that was easy and PAINLESS!
> >
> > "TheSQLGuru" wrote:
> >
> >> See Books Online and the BACKUP DATABASE and BACKUP LOG commands to write
> >> your own (not that difficult). Or right-click on a database name in the
> >> object browser in SQL Server Management Studio and select Tasks..Backup.
> >> or
> >> set up a maintenance plan (which has a wizard to help you). This is in
> >> the
> >> Management folder in SSMS.
> >>
> >> --
> >> Kevin G. Boles
> >> Indicium Resources, Inc.
> >> SQL Server MVP
> >> kgboles a earthlink dt net
> >>
> >>
> >> "MikeP125" wrote in message
> >> news:4705DE4A-0B1F-4346-AFCD-A7D928CD136A-at-microsoft.com...
> >> >I have just started working in SQL 2005 and was wondering what the
> >> >easiest
> >> >or
> >> > standard way is to backup the databases on the SQL Server.
> >> > Thanks...Mike
> >>
> >>
> >>
>
>
>

The transaction log allow for tings such as transactions (rollbacks) and also data integrity
(imagine a crash in the middle of a modification - half way through). I assume you are not
performing regular transaction log backups. If that is the case and you don't want to do this, then
just set the database to simple recovery model and then shrink the ldf file. If you do want to
perform regular transaction log backups, then have the Database in full recovery model - but don't forget
to do the log backups else the log files will only grow and grow. More details on shrinking etc:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"MikeP125" wrote in message
news:E118E5AB-C294-4110-8F32-69112DAF5CA4-at-microsoft.com...
> You were right, my TLogs are filling up the drive. What is the best way to
> back them up and purge them? A regular copy and paste? Can I delete the
> TLogs? What do the TLogs do for me?
>
> "TheSQLGuru" wrote:
>
>> Well, for any databases that are in FULL recovery mode, make sure you backup
>> the transaction logs at least occasionally. Otherwise you will be back here
>> in a few weeks or months asking why your tlogs have filled up the drive.
>> :-)
>>
>> --
>> Kevin G. Boles
>> Indicium Resources, Inc.
>> SQL Server MVP
>> kgboles a earthlink dt net
>>
>>
>> "MikeP125" wrote in message
>> news:71FD0587-71AB-4317-BAD0-D744C06683B3-at-microsoft.com...
>> > That Maintenance Plan feature ROCKS!! Thanks, that was easy and PAINLESS!
>> >
>> > "TheSQLGuru" wrote:
>> >
>> >> See Books Online and the BACKUP DATABASE and BACKUP LOG commands to write
>> >> your own (not that difficult). Or right-click on a database name in the
>> >> object browser in SQL Server Management Studio and select Tasks..Backup.
>> >> or
>> >> set up a maintenance plan (which has a wizard to help you). This is in
>> >> the
>> >> Management folder in SSMS.
>> >>
>> >> --
>> >> Kevin G. Boles
>> >> Indicium Resources, Inc.
>> >> SQL Server MVP
>> >> kgboles a earthlink dt net
>> >>
>> >>
>> >> "MikeP125" wrote in message
>> >> news:4705DE4A-0B1F-4346-AFCD-A7D928CD136A-at-microsoft.com...
>> >> >I have just started working in SQL 2005 and was wondering what the
>> >> >easiest
>> >> >or
>> >> > standard way is to backup the databases on the SQL Server.
>> >> > Thanks...Mike
>> >>
>> >>
>> >>
>>
>>
>>