When you do a full back-up of a sql server db, does that include the transaction logs or do they still have to be backed up seperately?
Thanks!Depends what your question is - does a full backup include all transactions in T-log? Yes. Does full backup checkpoint the T-log and truncate it? No. Does it shrink the T-log in a full backup? No.
To test this run this command:
dbcc sqlperf('logspace')
this will show you the percentage of your T-log used. Run a full backup then run the command again and you will see that the percentage did not go down. If you are having T-log growth problems, you probably want to back it up periodically.
Another good command to know for the T-log is this one:
select * from ::fn_dblog(null,null)
This will show you the entries in your active T-log.
HTH
Showing posts with label back-up. Show all posts
Showing posts with label back-up. Show all posts
Monday, March 19, 2012
Monday, February 13, 2012
Back-up Jobs
Greetings
I hope this is an easy question. I have a set of database (16 of them). I
have been using the enterprise manager to set-up back-up jobs for each one.
Can I use a script to insert the jobs in the SQL agent's job queue?
Thanks
Marc Walgren
Marc Walgren
Mitten Software "Powerful Solutions Made Easy"
1865 Wayzata Blvd, Suite 218, Long Lake, MN 55356 USA
Providing Web and Windows Products and Consulting Services
e-mail: mitten@.MittenSoftware.com www.mittensoftware.com
Sales: 800-825-5461 Voice: 952-745-4941 Fax: 952-745-4944
If I understand your question right, then yes, you can create the backup
scripts on your own. You just need to learn the BACKUP command, which is
documented in SQL Server Books Online.
Also, you can generate a script for an existing job, using Enterprise
Manager. Then you can change the parameters of that script, to create your
own job.
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Marc Walgren" <marcmittenATyahoo.com> wrote in message
news:u5%23uRBEwEHA.3080@.TK2MSFTNGP12.phx.gbl...
> Greetings
> I hope this is an easy question. I have a set of database (16 of them). I
> have been using the enterprise manager to set-up back-up jobs for each
one.
> Can I use a script to insert the jobs in the SQL agent's job queue?
> Thanks
> Marc Walgren
> --
> Marc Walgren
> Mitten Software "Powerful Solutions Made Easy"
> 1865 Wayzata Blvd, Suite 218, Long Lake, MN 55356 USA
> Providing Web and Windows Products and Consulting Services
> ---
--
> e-mail: mitten@.MittenSoftware.com www.mittensoftware.com
> Sales: 800-825-5461 Voice: 952-745-4941 Fax: 952-745-4944
>
>
|||Thanks
I forgot to look for the "Generate Sql Script" option on the job - all task
popup menu.
Marc
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23YNTGMEwEHA.3916@.TK2MSFTNGP10.phx.gbl...
> If I understand your question right, then yes, you can create the backup
> scripts on your own. You just need to learn the BACKUP command, which is
> documented in SQL Server Books Online.
> Also, you can generate a script for an existing job, using Enterprise
> Manager. Then you can change the parameters of that script, to create your
> own job.
> --
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Marc Walgren" <marcmittenATyahoo.com> wrote in message
> news:u5%23uRBEwEHA.3080@.TK2MSFTNGP12.phx.gbl...
> one.
> --
>
I hope this is an easy question. I have a set of database (16 of them). I
have been using the enterprise manager to set-up back-up jobs for each one.
Can I use a script to insert the jobs in the SQL agent's job queue?
Thanks
Marc Walgren
Marc Walgren
Mitten Software "Powerful Solutions Made Easy"
1865 Wayzata Blvd, Suite 218, Long Lake, MN 55356 USA
Providing Web and Windows Products and Consulting Services
e-mail: mitten@.MittenSoftware.com www.mittensoftware.com
Sales: 800-825-5461 Voice: 952-745-4941 Fax: 952-745-4944
If I understand your question right, then yes, you can create the backup
scripts on your own. You just need to learn the BACKUP command, which is
documented in SQL Server Books Online.
Also, you can generate a script for an existing job, using Enterprise
Manager. Then you can change the parameters of that script, to create your
own job.
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Marc Walgren" <marcmittenATyahoo.com> wrote in message
news:u5%23uRBEwEHA.3080@.TK2MSFTNGP12.phx.gbl...
> Greetings
> I hope this is an easy question. I have a set of database (16 of them). I
> have been using the enterprise manager to set-up back-up jobs for each
one.
> Can I use a script to insert the jobs in the SQL agent's job queue?
> Thanks
> Marc Walgren
> --
> Marc Walgren
> Mitten Software "Powerful Solutions Made Easy"
> 1865 Wayzata Blvd, Suite 218, Long Lake, MN 55356 USA
> Providing Web and Windows Products and Consulting Services
> ---
--
> e-mail: mitten@.MittenSoftware.com www.mittensoftware.com
> Sales: 800-825-5461 Voice: 952-745-4941 Fax: 952-745-4944
>
>
|||Thanks
I forgot to look for the "Generate Sql Script" option on the job - all task
popup menu.
Marc
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23YNTGMEwEHA.3916@.TK2MSFTNGP10.phx.gbl...
> If I understand your question right, then yes, you can create the backup
> scripts on your own. You just need to learn the BACKUP command, which is
> documented in SQL Server Books Online.
> Also, you can generate a script for an existing job, using Enterprise
> Manager. Then you can change the parameters of that script, to create your
> own job.
> --
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Marc Walgren" <marcmittenATyahoo.com> wrote in message
> news:u5%23uRBEwEHA.3080@.TK2MSFTNGP12.phx.gbl...
> one.
> --
>
Back-up Jobs
Greetings
I hope this is an easy question. I have a set of database (16 of them). I
have been using the enterprise manager to set-up back-up jobs for each one.
Can I use a script to insert the jobs in the SQL agent's job queue?
Thanks
Marc Walgren
--
Marc Walgren
Mitten Software "Powerful Solutions Made Easy"
1865 Wayzata Blvd, Suite 218, Long Lake, MN 55356 USA
Providing Web and Windows Products and Consulting Services
----
e-mail: mitten@.MittenSoftware.com www.mittensoftware.com
Sales: 800-825-5461 Voice: 952-745-4941 Fax: 952-745-4944If I understand your question right, then yes, you can create the backup
scripts on your own. You just need to learn the BACKUP command, which is
documented in SQL Server Books Online.
Also, you can generate a script for an existing job, using Enterprise
Manager. Then you can change the parameters of that script, to create your
own job.
--
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Marc Walgren" <marcmittenATyahoo.com> wrote in message
news:u5%23uRBEwEHA.3080@.TK2MSFTNGP12.phx.gbl...
> Greetings
> I hope this is an easy question. I have a set of database (16 of them). I
> have been using the enterprise manager to set-up back-up jobs for each
one.
> Can I use a script to insert the jobs in the SQL agent's job queue?
> Thanks
> Marc Walgren
> --
> Marc Walgren
> Mitten Software "Powerful Solutions Made Easy"
> 1865 Wayzata Blvd, Suite 218, Long Lake, MN 55356 USA
> Providing Web and Windows Products and Consulting Services
> ---
--
> e-mail: mitten@.MittenSoftware.com www.mittensoftware.com
> Sales: 800-825-5461 Voice: 952-745-4941 Fax: 952-745-4944
>
>|||Thanks
I forgot to look for the "Generate Sql Script" option on the job - all task
popup menu.
Marc
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23YNTGMEwEHA.3916@.TK2MSFTNGP10.phx.gbl...
> If I understand your question right, then yes, you can create the backup
> scripts on your own. You just need to learn the BACKUP command, which is
> documented in SQL Server Books Online.
> Also, you can generate a script for an existing job, using Enterprise
> Manager. Then you can change the parameters of that script, to create your
> own job.
> --
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Marc Walgren" <marcmittenATyahoo.com> wrote in message
> news:u5%23uRBEwEHA.3080@.TK2MSFTNGP12.phx.gbl...
>> Greetings
>> I hope this is an easy question. I have a set of database (16 of them). I
>> have been using the enterprise manager to set-up back-up jobs for each
> one.
>> Can I use a script to insert the jobs in the SQL agent's job queue?
>> Thanks
>> Marc Walgren
>> --
>> Marc Walgren
>> Mitten Software "Powerful Solutions Made Easy"
>> 1865 Wayzata Blvd, Suite 218, Long Lake, MN 55356 USA
>> Providing Web and Windows Products and Consulting Services
>> ---
> --
>> e-mail: mitten@.MittenSoftware.com www.mittensoftware.com
>> Sales: 800-825-5461 Voice: 952-745-4941 Fax: 952-745-4944
>>
>
I hope this is an easy question. I have a set of database (16 of them). I
have been using the enterprise manager to set-up back-up jobs for each one.
Can I use a script to insert the jobs in the SQL agent's job queue?
Thanks
Marc Walgren
--
Marc Walgren
Mitten Software "Powerful Solutions Made Easy"
1865 Wayzata Blvd, Suite 218, Long Lake, MN 55356 USA
Providing Web and Windows Products and Consulting Services
----
e-mail: mitten@.MittenSoftware.com www.mittensoftware.com
Sales: 800-825-5461 Voice: 952-745-4941 Fax: 952-745-4944If I understand your question right, then yes, you can create the backup
scripts on your own. You just need to learn the BACKUP command, which is
documented in SQL Server Books Online.
Also, you can generate a script for an existing job, using Enterprise
Manager. Then you can change the parameters of that script, to create your
own job.
--
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Marc Walgren" <marcmittenATyahoo.com> wrote in message
news:u5%23uRBEwEHA.3080@.TK2MSFTNGP12.phx.gbl...
> Greetings
> I hope this is an easy question. I have a set of database (16 of them). I
> have been using the enterprise manager to set-up back-up jobs for each
one.
> Can I use a script to insert the jobs in the SQL agent's job queue?
> Thanks
> Marc Walgren
> --
> Marc Walgren
> Mitten Software "Powerful Solutions Made Easy"
> 1865 Wayzata Blvd, Suite 218, Long Lake, MN 55356 USA
> Providing Web and Windows Products and Consulting Services
> ---
--
> e-mail: mitten@.MittenSoftware.com www.mittensoftware.com
> Sales: 800-825-5461 Voice: 952-745-4941 Fax: 952-745-4944
>
>|||Thanks
I forgot to look for the "Generate Sql Script" option on the job - all task
popup menu.
Marc
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23YNTGMEwEHA.3916@.TK2MSFTNGP10.phx.gbl...
> If I understand your question right, then yes, you can create the backup
> scripts on your own. You just need to learn the BACKUP command, which is
> documented in SQL Server Books Online.
> Also, you can generate a script for an existing job, using Enterprise
> Manager. Then you can change the parameters of that script, to create your
> own job.
> --
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Marc Walgren" <marcmittenATyahoo.com> wrote in message
> news:u5%23uRBEwEHA.3080@.TK2MSFTNGP12.phx.gbl...
>> Greetings
>> I hope this is an easy question. I have a set of database (16 of them). I
>> have been using the enterprise manager to set-up back-up jobs for each
> one.
>> Can I use a script to insert the jobs in the SQL agent's job queue?
>> Thanks
>> Marc Walgren
>> --
>> Marc Walgren
>> Mitten Software "Powerful Solutions Made Easy"
>> 1865 Wayzata Blvd, Suite 218, Long Lake, MN 55356 USA
>> Providing Web and Windows Products and Consulting Services
>> ---
> --
>> e-mail: mitten@.MittenSoftware.com www.mittensoftware.com
>> Sales: 800-825-5461 Voice: 952-745-4941 Fax: 952-745-4944
>>
>
Back-up Jobs
Greetings
I hope this is an easy question. I have a set of database (16 of them). I
have been using the enterprise manager to set-up back-up jobs for each one.
Can I use a script to insert the jobs in the SQL agent's job queue?
Thanks
Marc Walgren
Marc Walgren
Mitten Software "Powerful Solutions Made Easy"
1865 Wayzata Blvd, Suite 218, Long Lake, MN 55356 USA
Providing Web and Windows Products and Consulting Services
----
e-mail: mitten@.MittenSoftware.com www.mittensoftware.com
Sales: 800-825-5461 Voice: 952-745-4941 Fax: 952-745-4944If I understand your question right, then yes, you can create the backup
scripts on your own. You just need to learn the BACKUP command, which is
documented in SQL Server Books Online.
Also, you can generate a script for an existing job, using Enterprise
Manager. Then you can change the parameters of that script, to create your
own job.
--
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Marc Walgren" <marcmittenATyahoo.com> wrote in message
news:u5%23uRBEwEHA.3080@.TK2MSFTNGP12.phx.gbl...
> Greetings
> I hope this is an easy question. I have a set of database (16 of them). I
> have been using the enterprise manager to set-up back-up jobs for each
one.
> Can I use a script to insert the jobs in the SQL agent's job queue?
> Thanks
> Marc Walgren
> --
> Marc Walgren
> Mitten Software "Powerful Solutions Made Easy"
> 1865 Wayzata Blvd, Suite 218, Long Lake, MN 55356 USA
> Providing Web and Windows Products and Consulting Services
> ---
--
> e-mail: mitten@.MittenSoftware.com www.mittensoftware.com
> Sales: 800-825-5461 Voice: 952-745-4941 Fax: 952-745-4944
>
>|||Thanks
I forgot to look for the "Generate Sql Script" option on the job - all task
popup menu.
Marc
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23YNTGMEwEHA.3916@.TK2MSFTNGP10.phx.gbl...
> If I understand your question right, then yes, you can create the backup
> scripts on your own. You just need to learn the BACKUP command, which is
> documented in SQL Server Books Online.
> Also, you can generate a script for an existing job, using Enterprise
> Manager. Then you can change the parameters of that script, to create your
> own job.
> --
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Marc Walgren" <marcmittenATyahoo.com> wrote in message
> news:u5%23uRBEwEHA.3080@.TK2MSFTNGP12.phx.gbl...
> one.
> --
>
I hope this is an easy question. I have a set of database (16 of them). I
have been using the enterprise manager to set-up back-up jobs for each one.
Can I use a script to insert the jobs in the SQL agent's job queue?
Thanks
Marc Walgren
Marc Walgren
Mitten Software "Powerful Solutions Made Easy"
1865 Wayzata Blvd, Suite 218, Long Lake, MN 55356 USA
Providing Web and Windows Products and Consulting Services
----
e-mail: mitten@.MittenSoftware.com www.mittensoftware.com
Sales: 800-825-5461 Voice: 952-745-4941 Fax: 952-745-4944If I understand your question right, then yes, you can create the backup
scripts on your own. You just need to learn the BACKUP command, which is
documented in SQL Server Books Online.
Also, you can generate a script for an existing job, using Enterprise
Manager. Then you can change the parameters of that script, to create your
own job.
--
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Marc Walgren" <marcmittenATyahoo.com> wrote in message
news:u5%23uRBEwEHA.3080@.TK2MSFTNGP12.phx.gbl...
> Greetings
> I hope this is an easy question. I have a set of database (16 of them). I
> have been using the enterprise manager to set-up back-up jobs for each
one.
> Can I use a script to insert the jobs in the SQL agent's job queue?
> Thanks
> Marc Walgren
> --
> Marc Walgren
> Mitten Software "Powerful Solutions Made Easy"
> 1865 Wayzata Blvd, Suite 218, Long Lake, MN 55356 USA
> Providing Web and Windows Products and Consulting Services
> ---
--
> e-mail: mitten@.MittenSoftware.com www.mittensoftware.com
> Sales: 800-825-5461 Voice: 952-745-4941 Fax: 952-745-4944
>
>|||Thanks
I forgot to look for the "Generate Sql Script" option on the job - all task
popup menu.
Marc
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23YNTGMEwEHA.3916@.TK2MSFTNGP10.phx.gbl...
> If I understand your question right, then yes, you can create the backup
> scripts on your own. You just need to learn the BACKUP command, which is
> documented in SQL Server Books Online.
> Also, you can generate a script for an existing job, using Enterprise
> Manager. Then you can change the parameters of that script, to create your
> own job.
> --
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Marc Walgren" <marcmittenATyahoo.com> wrote in message
> news:u5%23uRBEwEHA.3080@.TK2MSFTNGP12.phx.gbl...
> one.
> --
>
Subscribe to:
Posts (Atom)