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
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...
>
>
|||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...[vbcol=seagreen]
> 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:
Friday, February 24, 2012
Backup-Questions about Logshipping
Labels:
allready,
backup,
backup-questions,
database,
google,
logshipping,
microsoft,
mysql,
oracle,
questionsabout,
server,
situation2,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment