Re: Backup questions
From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 06/01/05
- Next message: Hari Prasad: "Re: how to determine who has dba privileges?"
- Previous message: bagman3rd: "Backup questions"
- In reply to: bagman3rd: "Backup questions"
- Next in thread: bagman3rd: "Re: Backup questions"
- Reply: bagman3rd: "Re: Backup questions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 2 Jun 2005 02:45:34 +0530
Yes, You can restore the backup to any other server.
See this article:-
http://www.databasejournal.com/features/mssql/article.php/2232371
Thanks
Hari
SQL Server MVP
"bagman3rd" <bagman3rd@discussions.microsoft.com> wrote in message
news:31ECF89A-A1E8-40C3-8934-406227006912@microsoft.com...
>I was wondering if someone could point me in the right direction and/or
>give
> me a quick breakdown on SQL Server backups. I work in Environmental
> Consulting, and all of my databases are geochemical/hydrogeological
> databases. None of them are very big(300 megs for all my databases), and
> the
> data rarely changes. I do add data to the databases when it comes in, but
> I
> do have sp's that I am updating/creating on a weekly basis. I really only
> need to backup my databases once a week or maybe twice a month, and I have
> been shutting down the SQL Service Manager, copying the db files to cd,
> then
> restarting the SQL service. My sys admin wants to use the backup
> procedure
> within SQL Server, but I really dont understand how the restoring works.
> If
> you use the backup procedures within SQL Server, and your physical server
> blows up, can you restore the db's on another machine. How does this
> work?
> I really like being able to have two detached database files which can be
> re-attached to any machine, but do not understand how to restore the
> backup
> db files, or how this works even. Thanks for you help.
>
> Archer
- Next message: Hari Prasad: "Re: how to determine who has dba privileges?"
- Previous message: bagman3rd: "Backup questions"
- In reply to: bagman3rd: "Backup questions"
- Next in thread: bagman3rd: "Re: Backup questions"
- Reply: bagman3rd: "Re: Backup questions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
