Fresh DBA doubts - Help appreciated

Hi,
1. How do I move data from a table along with the Table
stucture into another Database with same structure as
source database except the table to be moved.
2. How do i ask SQL Server Agent to backup to a Network
Drive.
3. one of my colleague suggests this backup plan. nighty
full backups, differential backups every four hours
between fulls, and transaction log backup every 1 hour in
between, What should be the sequence of Restoration in
case of failure. Also any other better solution with
Full/Differential/Transactional combination?
Regards
Chip
1. DTS.
2. Ensure that your SQL Server Agent startup account has access to a
network share, and use the UNC naming convention in your backup statement.
3. Depends on how much data you are willing to lose and the amount of time
you are allowed to restore a database. In your current setup, you will lose
at most 1 hour's worth of work. Is this acceptable? For other
considerations, read the Data Recovery Best Practices document at
http://www.lumigent.com/solutions/papers.htm.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"chip" <anonymous@.discussions.microsoft.com> wrote in message
news:1ecfe01c4573f$3271c710$a301280a@.phx.gbl...
> Hi,
> 1. How do I move data from a table along with the Table
> stucture into another Database with same structure as
> source database except the table to be moved.
>
> 2. How do i ask SQL Server Agent to backup to a Network
> Drive.
>
> 3. one of my colleague suggests this backup plan. nighty
> full backups, differential backups every four hours
> between fulls, and transaction log backup every 1 hour in
> between, What should be the sequence of Restoration in
> case of failure. Also any other better solution with
> Full/Differential/Transactional combination?
> Regards
> Chip
|||Sytax for #2 would be
backup database prod to disk = '\\fileserver\fileshare\prod.bak' with init
Make sure that the NT login that SQL Server and SQL Agent use have
permissions on the file share.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"chip" <anonymous@.discussions.microsoft.com> wrote in message
news:1ecfe01c4573f$3271c710$a301280a@.phx.gbl...
> Hi,
> 1. How do I move data from a table along with the Table
> stucture into another Database with same structure as
> source database except the table to be moved.
>
> 2. How do i ask SQL Server Agent to backup to a Network
> Drive.
>
> 3. one of my colleague suggests this backup plan. nighty
> full backups, differential backups every four hours
> between fulls, and transaction log backup every 1 hour in
> between, What should be the sequence of Restoration in
> case of failure. Also any other better solution with
> Full/Differential/Transactional combination?
> Regards
> Chip
|||Thanks to you both for the inputs.
Regards
Chip
>--Original Message--
>1. DTS.
>2. Ensure that your SQL Server Agent startup account has
access to a
>network share, and use the UNC naming convention in your
backup statement.
>3. Depends on how much data you are willing to lose and
the amount of time
>you are allowed to restore a database. In your current
setup, you will lose
>at most 1 hour's worth of work. Is this acceptable? For
other
>considerations, read the Data Recovery Best Practices
document at
>http://www.lumigent.com/solutions/papers.htm.
>Peter Yeoh
>http://www.yohz.com
>Need smaller SQL2K backup files? Try MiniSQLBackup
>
>"chip" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:1ecfe01c4573f$3271c710$a301280a@.phx.gbl...
in
>
>.
>