Hi All,
I would need to do a Knowledge transfer to my client. So I require
Knowledge transfer Template or Knowledge transfer plan for SQL Server
DBA role. Please guide me on this or please send me any useful
documents or useful links?
Thanks and regards
Hi
I don't know of this being written anywhere but here are a few suggestions:
Write down what should be general or expected knowledge needed
Write down where he can find out about this in more detail e.g. web sites,
recommended courses/books etc...
Make sure system(s) are fully documented in an form where the information
can be found and understood.
Write down specific knowledge needed
Write down a framework for documentation/tutorials etc that can be used to
transfer this information
Write down a plan for how this will be transferred including what the client
needs to know before you start and the timescales involved.
Agree the above with the client and execute it, making sure that you note
any additional information that is required whilst carrying out the plan.
Agree any additional support needs required including leaving your contact
details.
John
"Praveen" wrote:
> Hi All,
> I would need to do a Knowledge transfer to my client. So I require
> Knowledge transfer Template or Knowledge transfer plan for SQL Server
> DBA role. Please guide me on this or please send me any useful
> documents or useful links?
> Thanks and regards
>
Showing posts with label plan. Show all posts
Showing posts with label plan. Show all posts
Friday, March 30, 2012
Knowlege transfer Template
Hi All,
I would need to do a Knowledge transfer to my client. So I require
Knowledge transfer Template or Knowledge transfer plan for SQL Server
DBA role. Please guide me on this or please send me any useful
documents or useful links?
Thanks and regardsHi
I don't know of this being written anywhere but here are a few suggestions:
Write down what should be general or expected knowledge needed
Write down where he can find out about this in more detail e.g. web sites,
recommended courses/books etc...
Make sure system(s) are fully documented in an form where the information
can be found and understood.
Write down specific knowledge needed
Write down a framework for documentation/tutorials etc that can be used to
transfer this information
Write down a plan for how this will be transferred including what the client
needs to know before you start and the timescales involved.
Agree the above with the client and execute it, making sure that you note
any additional information that is required whilst carrying out the plan.
Agree any additional support needs required including leaving your contact
details.
John
"Praveen" wrote:
> Hi All,
> I would need to do a Knowledge transfer to my client. So I require
> Knowledge transfer Template or Knowledge transfer plan for SQL Server
> DBA role. Please guide me on this or please send me any useful
> documents or useful links?
> Thanks and regards
>
I would need to do a Knowledge transfer to my client. So I require
Knowledge transfer Template or Knowledge transfer plan for SQL Server
DBA role. Please guide me on this or please send me any useful
documents or useful links?
Thanks and regardsHi
I don't know of this being written anywhere but here are a few suggestions:
Write down what should be general or expected knowledge needed
Write down where he can find out about this in more detail e.g. web sites,
recommended courses/books etc...
Make sure system(s) are fully documented in an form where the information
can be found and understood.
Write down specific knowledge needed
Write down a framework for documentation/tutorials etc that can be used to
transfer this information
Write down a plan for how this will be transferred including what the client
needs to know before you start and the timescales involved.
Agree the above with the client and execute it, making sure that you note
any additional information that is required whilst carrying out the plan.
Agree any additional support needs required including leaving your contact
details.
John
"Praveen" wrote:
> Hi All,
> I would need to do a Knowledge transfer to my client. So I require
> Knowledge transfer Template or Knowledge transfer plan for SQL Server
> DBA role. Please guide me on this or please send me any useful
> documents or useful links?
> Thanks and regards
>
Knowlege transfer Template
Hi All,
I would need to do a Knowledge transfer to my client. So I require
Knowledge transfer Template or Knowledge transfer plan for SQL Server
DBA role. Please guide me on this or please send me any useful
documents or useful links?
Thanks and regardsHi
I don't know of this being written anywhere but here are a few suggestions:
Write down what should be general or expected knowledge needed
Write down where he can find out about this in more detail e.g. web sites,
recommended courses/books etc...
Make sure system(s) are fully documented in an form where the information
can be found and understood.
Write down specific knowledge needed
Write down a framework for documentation/tutorials etc that can be used to
transfer this information
Write down a plan for how this will be transferred including what the client
needs to know before you start and the timescales involved.
Agree the above with the client and execute it, making sure that you note
any additional information that is required whilst carrying out the plan.
Agree any additional support needs required including leaving your contact
details.
John
"Praveen" wrote:
> Hi All,
> I would need to do a Knowledge transfer to my client. So I require
> Knowledge transfer Template or Knowledge transfer plan for SQL Server
> DBA role. Please guide me on this or please send me any useful
> documents or useful links?
> Thanks and regards
>sql
I would need to do a Knowledge transfer to my client. So I require
Knowledge transfer Template or Knowledge transfer plan for SQL Server
DBA role. Please guide me on this or please send me any useful
documents or useful links?
Thanks and regardsHi
I don't know of this being written anywhere but here are a few suggestions:
Write down what should be general or expected knowledge needed
Write down where he can find out about this in more detail e.g. web sites,
recommended courses/books etc...
Make sure system(s) are fully documented in an form where the information
can be found and understood.
Write down specific knowledge needed
Write down a framework for documentation/tutorials etc that can be used to
transfer this information
Write down a plan for how this will be transferred including what the client
needs to know before you start and the timescales involved.
Agree the above with the client and execute it, making sure that you note
any additional information that is required whilst carrying out the plan.
Agree any additional support needs required including leaving your contact
details.
John
"Praveen" wrote:
> Hi All,
> I would need to do a Knowledge transfer to my client. So I require
> Knowledge transfer Template or Knowledge transfer plan for SQL Server
> DBA role. Please guide me on this or please send me any useful
> documents or useful links?
> Thanks and regards
>sql
Friday, February 24, 2012
Keep only X # of backups when appending to BU file
Using SQL Server 2005 STD, is there a way to create a maintance plan to
backup the database, appending to a file, but only keeping the last X number
of backups?
I would like to keep 4 full backups at a time. When the 5th backup occurs, I
would like the first to be deleted.
I've seen options like this in 3rd party backup tools, but is there a way to
do this natively w/ SQL Server?
Have a look at the expire parameter of the backup command. From
http://msdn2.microsoft.com/en-us/library/ms187510.aspx
a.. To have the backup set expire after a specific number of days, click
After (the default option), and enter the number of days after set creation
that the set will expire. This value can be from 0 to 99999 days; a value of
0 days means that the backup set will never expire.
The default value is set in the Default backup media retention (in days)
option of the Server Properties dialog box (Database Settings Page). To
access this, right-click the server name in Object Explorer and select
properties; then select the Database Settings page.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:DEA2E6D1-DB67-42F7-8406-E37EB553AEA9@.microsoft.com...
> Using SQL Server 2005 STD, is there a way to create a maintance plan to
> backup the database, appending to a file, but only keeping the last X
> number
> of backups?
> I would like to keep 4 full backups at a time. When the 5th backup occurs,
> I
> would like the first to be deleted.
> I've seen options like this in 3rd party backup tools, but is there a way
> to
> do this natively w/ SQL Server?
|||If every backup goes to the same file, then the answer is no. There
is no way for SQL Server to drop old backups from the front of the
file. The solution is for each backup to go to an individual file.
Roy Harvey
Beacon Falls, CT
On Tue, 19 Sep 2006 18:34:01 -0700, Dan
<Dan@.discussions.microsoft.com> wrote:
>Using SQL Server 2005 STD, is there a way to create a maintance plan to
>backup the database, appending to a file, but only keeping the last X number
>of backups?
>I would like to keep 4 full backups at a time. When the 5th backup occurs, I
>would like the first to be deleted.
>I've seen options like this in 3rd party backup tools, but is there a way to
>do this natively w/ SQL Server?
backup the database, appending to a file, but only keeping the last X number
of backups?
I would like to keep 4 full backups at a time. When the 5th backup occurs, I
would like the first to be deleted.
I've seen options like this in 3rd party backup tools, but is there a way to
do this natively w/ SQL Server?
Have a look at the expire parameter of the backup command. From
http://msdn2.microsoft.com/en-us/library/ms187510.aspx
a.. To have the backup set expire after a specific number of days, click
After (the default option), and enter the number of days after set creation
that the set will expire. This value can be from 0 to 99999 days; a value of
0 days means that the backup set will never expire.
The default value is set in the Default backup media retention (in days)
option of the Server Properties dialog box (Database Settings Page). To
access this, right-click the server name in Object Explorer and select
properties; then select the Database Settings page.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:DEA2E6D1-DB67-42F7-8406-E37EB553AEA9@.microsoft.com...
> Using SQL Server 2005 STD, is there a way to create a maintance plan to
> backup the database, appending to a file, but only keeping the last X
> number
> of backups?
> I would like to keep 4 full backups at a time. When the 5th backup occurs,
> I
> would like the first to be deleted.
> I've seen options like this in 3rd party backup tools, but is there a way
> to
> do this natively w/ SQL Server?
|||If every backup goes to the same file, then the answer is no. There
is no way for SQL Server to drop old backups from the front of the
file. The solution is for each backup to go to an individual file.
Roy Harvey
Beacon Falls, CT
On Tue, 19 Sep 2006 18:34:01 -0700, Dan
<Dan@.discussions.microsoft.com> wrote:
>Using SQL Server 2005 STD, is there a way to create a maintance plan to
>backup the database, appending to a file, but only keeping the last X number
>of backups?
>I would like to keep 4 full backups at a time. When the 5th backup occurs, I
>would like the first to be deleted.
>I've seen options like this in 3rd party backup tools, but is there a way to
>do this natively w/ SQL Server?
Keep only X # of backups when appending to BU file
Using SQL Server 2005 STD, is there a way to create a maintance plan to
backup the database, appending to a file, but only keeping the last X number
of backups?
I would like to keep 4 full backups at a time. When the 5th backup occurs, I
would like the first to be deleted.
I've seen options like this in 3rd party backup tools, but is there a way to
do this natively w/ SQL Server?Have a look at the expire parameter of the backup command. From
http://msdn2.microsoft.com/en-us/library/ms187510.aspx
a.. To have the backup set expire after a specific number of days, click
After (the default option), and enter the number of days after set creation
that the set will expire. This value can be from 0 to 99999 days; a value of
0 days means that the backup set will never expire.
The default value is set in the Default backup media retention (in days)
option of the Server Properties dialog box (Database Settings Page). To
access this, right-click the server name in Object Explorer and select
properties; then select the Database Settings page.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:DEA2E6D1-DB67-42F7-8406-E37EB553AEA9@.microsoft.com...
> Using SQL Server 2005 STD, is there a way to create a maintance plan to
> backup the database, appending to a file, but only keeping the last X
> number
> of backups?
> I would like to keep 4 full backups at a time. When the 5th backup occurs,
> I
> would like the first to be deleted.
> I've seen options like this in 3rd party backup tools, but is there a way
> to
> do this natively w/ SQL Server?|||If every backup goes to the same file, then the answer is no. There
is no way for SQL Server to drop old backups from the front of the
file. The solution is for each backup to go to an individual file.
Roy Harvey
Beacon Falls, CT
On Tue, 19 Sep 2006 18:34:01 -0700, Dan
<Dan@.discussions.microsoft.com> wrote:
>Using SQL Server 2005 STD, is there a way to create a maintance plan to
>backup the database, appending to a file, but only keeping the last X numbe
r
>of backups?
>I would like to keep 4 full backups at a time. When the 5th backup occurs,
I
>would like the first to be deleted.
>I've seen options like this in 3rd party backup tools, but is there a way t
o
>do this natively w/ SQL Server?
backup the database, appending to a file, but only keeping the last X number
of backups?
I would like to keep 4 full backups at a time. When the 5th backup occurs, I
would like the first to be deleted.
I've seen options like this in 3rd party backup tools, but is there a way to
do this natively w/ SQL Server?Have a look at the expire parameter of the backup command. From
http://msdn2.microsoft.com/en-us/library/ms187510.aspx
a.. To have the backup set expire after a specific number of days, click
After (the default option), and enter the number of days after set creation
that the set will expire. This value can be from 0 to 99999 days; a value of
0 days means that the backup set will never expire.
The default value is set in the Default backup media retention (in days)
option of the Server Properties dialog box (Database Settings Page). To
access this, right-click the server name in Object Explorer and select
properties; then select the Database Settings page.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:DEA2E6D1-DB67-42F7-8406-E37EB553AEA9@.microsoft.com...
> Using SQL Server 2005 STD, is there a way to create a maintance plan to
> backup the database, appending to a file, but only keeping the last X
> number
> of backups?
> I would like to keep 4 full backups at a time. When the 5th backup occurs,
> I
> would like the first to be deleted.
> I've seen options like this in 3rd party backup tools, but is there a way
> to
> do this natively w/ SQL Server?|||If every backup goes to the same file, then the answer is no. There
is no way for SQL Server to drop old backups from the front of the
file. The solution is for each backup to go to an individual file.
Roy Harvey
Beacon Falls, CT
On Tue, 19 Sep 2006 18:34:01 -0700, Dan
<Dan@.discussions.microsoft.com> wrote:
>Using SQL Server 2005 STD, is there a way to create a maintance plan to
>backup the database, appending to a file, but only keeping the last X numbe
r
>of backups?
>I would like to keep 4 full backups at a time. When the 5th backup occurs,
I
>would like the first to be deleted.
>I've seen options like this in 3rd party backup tools, but is there a way t
o
>do this natively w/ SQL Server?
Keep only X # of backups when appending to BU file
Using SQL Server 2005 STD, is there a way to create a maintance plan to
backup the database, appending to a file, but only keeping the last X number
of backups?
I would like to keep 4 full backups at a time. When the 5th backup occurs, I
would like the first to be deleted.
I've seen options like this in 3rd party backup tools, but is there a way to
do this natively w/ SQL Server?Have a look at the expire parameter of the backup command. From
http://msdn2.microsoft.com/en-us/library/ms187510.aspx
a.. To have the backup set expire after a specific number of days, click
After (the default option), and enter the number of days after set creation
that the set will expire. This value can be from 0 to 99999 days; a value of
0 days means that the backup set will never expire.
The default value is set in the Default backup media retention (in days)
option of the Server Properties dialog box (Database Settings Page). To
access this, right-click the server name in Object Explorer and select
properties; then select the Database Settings page.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:DEA2E6D1-DB67-42F7-8406-E37EB553AEA9@.microsoft.com...
> Using SQL Server 2005 STD, is there a way to create a maintance plan to
> backup the database, appending to a file, but only keeping the last X
> number
> of backups?
> I would like to keep 4 full backups at a time. When the 5th backup occurs,
> I
> would like the first to be deleted.
> I've seen options like this in 3rd party backup tools, but is there a way
> to
> do this natively w/ SQL Server?|||If every backup goes to the same file, then the answer is no. There
is no way for SQL Server to drop old backups from the front of the
file. The solution is for each backup to go to an individual file.
Roy Harvey
Beacon Falls, CT
On Tue, 19 Sep 2006 18:34:01 -0700, Dan
<Dan@.discussions.microsoft.com> wrote:
>Using SQL Server 2005 STD, is there a way to create a maintance plan to
>backup the database, appending to a file, but only keeping the last X number
>of backups?
>I would like to keep 4 full backups at a time. When the 5th backup occurs, I
>would like the first to be deleted.
>I've seen options like this in 3rd party backup tools, but is there a way to
>do this natively w/ SQL Server?
backup the database, appending to a file, but only keeping the last X number
of backups?
I would like to keep 4 full backups at a time. When the 5th backup occurs, I
would like the first to be deleted.
I've seen options like this in 3rd party backup tools, but is there a way to
do this natively w/ SQL Server?Have a look at the expire parameter of the backup command. From
http://msdn2.microsoft.com/en-us/library/ms187510.aspx
a.. To have the backup set expire after a specific number of days, click
After (the default option), and enter the number of days after set creation
that the set will expire. This value can be from 0 to 99999 days; a value of
0 days means that the backup set will never expire.
The default value is set in the Default backup media retention (in days)
option of the Server Properties dialog box (Database Settings Page). To
access this, right-click the server name in Object Explorer and select
properties; then select the Database Settings page.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:DEA2E6D1-DB67-42F7-8406-E37EB553AEA9@.microsoft.com...
> Using SQL Server 2005 STD, is there a way to create a maintance plan to
> backup the database, appending to a file, but only keeping the last X
> number
> of backups?
> I would like to keep 4 full backups at a time. When the 5th backup occurs,
> I
> would like the first to be deleted.
> I've seen options like this in 3rd party backup tools, but is there a way
> to
> do this natively w/ SQL Server?|||If every backup goes to the same file, then the answer is no. There
is no way for SQL Server to drop old backups from the front of the
file. The solution is for each backup to go to an individual file.
Roy Harvey
Beacon Falls, CT
On Tue, 19 Sep 2006 18:34:01 -0700, Dan
<Dan@.discussions.microsoft.com> wrote:
>Using SQL Server 2005 STD, is there a way to create a maintance plan to
>backup the database, appending to a file, but only keeping the last X number
>of backups?
>I would like to keep 4 full backups at a time. When the 5th backup occurs, I
>would like the first to be deleted.
>I've seen options like this in 3rd party backup tools, but is there a way to
>do this natively w/ SQL Server?
Subscribe to:
Comments (Atom)