Backup-Questions about Logshipping

Hi,
I am new on this topic and I allready use google. I have some questions
about Backup a Server that is Logshipping.
Situation:
2 SQL 2000 Server
Logshipping a 100GB DB from Server 1 to Server 2. --> it's working!
Questions:
I need all databases (System-DBs and the Logshipped) on my backup.
What is possible to backup and on witch way (Full, Copy,..)?
Is there a way to truncate the Logs of the system-DBs?
Thanks a lot for helping me.
RalphRalph
Do yopu want all databases including system to be copied (.BAK) on remote
server?
Backup all system databases and use COPY of the DOS function to copy the
files on remote server
"Ralph" <Ralph@.discussions.microsoft.com> wrote in message
news:6BFF8189-DC17-404C-B274-88E3EFA2FA50@.microsoft.com...
> Hi,
> I am new on this topic and I allready use google. I have some questions
> about Backup a Server that is Logshipping.
> Situation:
> 2 SQL 2000 Server
> Logshipping a 100GB DB from Server 1 to Server 2. --> it's working!
> Questions:
> I need all databases (System-DBs and the Logshipped) on my backup.
> What is possible to backup and on witch way (Full, Copy,..)?
> Is there a way to truncate the Logs of the system-DBs?
> Thanks a lot for helping me.
> Ralph|||Hi Uri
I would like to backup the System-Databases in SQL. Like a fullbackup.
not copy in dos or windows.
Thanks for the fast reply.
"Uri Dimant" wrote:
> Ralph
> Do yopu want all databases including system to be copied (.BAK) on remote
> server?
> Backup all system databases and use COPY of the DOS function to copy the
> files on remote server
>
> "Ralph" <Ralph@.discussions.microsoft.com> wrote in message
> news:6BFF8189-DC17-404C-B274-88E3EFA2FA50@.microsoft.com...
> > Hi,
> >
> > I am new on this topic and I allready use google. I have some questions
> > about Backup a Server that is Logshipping.
> >
> > Situation:
> > 2 SQL 2000 Server
> > Logshipping a 100GB DB from Server 1 to Server 2. --> it's working!
> >
> > Questions:
> > I need all databases (System-DBs and the Logshipped) on my backup.
> > What is possible to backup and on witch way (Full, Copy,..)?
> > Is there a way to truncate the Logs of the system-DBs?
> >
> > Thanks a lot for helping me.
> >
> > Ralph
>
>|||Ralph
Take a look at Maintanace Plan to create backup for system (and not only)
databases
"Ralph" <Ralph@.discussions.microsoft.com> wrote in message
news:27757BB3-4DE7-4724-88E5-2D9E4F619C3B@.microsoft.com...
> Hi Uri
> I would like to backup the System-Databases in SQL. Like a fullbackup.
> not copy in dos or windows.
> Thanks for the fast reply.
> "Uri Dimant" wrote:
>> Ralph
>> Do yopu want all databases including system to be copied (.BAK) on remote
>> server?
>> Backup all system databases and use COPY of the DOS function to copy the
>> files on remote server
>>
>> "Ralph" <Ralph@.discussions.microsoft.com> wrote in message
>> news:6BFF8189-DC17-404C-B274-88E3EFA2FA50@.microsoft.com...
>> > Hi,
>> >
>> > I am new on this topic and I allready use google. I have some questions
>> > about Backup a Server that is Logshipping.
>> >
>> > Situation:
>> > 2 SQL 2000 Server
>> > Logshipping a 100GB DB from Server 1 to Server 2. --> it's working!
>> >
>> > Questions:
>> > I need all databases (System-DBs and the Logshipped) on my backup.
>> > What is possible to backup and on witch way (Full, Copy,..)?
>> > Is there a way to truncate the Logs of the system-DBs?
>> >
>> > Thanks a lot for helping me.
>> >
>> > Ralph
>>|||tempdb: Can't backup - no reason to.
master - can only do db backup (can't do log backup)
model - can do log backup, but overkill
msdb - can do log backup, might be overkill. However Agent sets it to simple recovery at startup.
As long as a db is in simple recovery then there is no reason to "truncate the log" for that db.
Restoring the system db's are not that easy, though... For instance a good start is KB 227071.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ralph" <Ralph@.discussions.microsoft.com> wrote in message
news:6BFF8189-DC17-404C-B274-88E3EFA2FA50@.microsoft.com...
> Hi,
> I am new on this topic and I allready use google. I have some questions
> about Backup a Server that is Logshipping.
> Situation:
> 2 SQL 2000 Server
> Logshipping a 100GB DB from Server 1 to Server 2. --> it's working!
> Questions:
> I need all databases (System-DBs and the Logshipped) on my backup.
> What is possible to backup and on witch way (Full, Copy,..)?
> Is there a way to truncate the Logs of the system-DBs?
> Thanks a lot for helping me.
> Ralph