hotbackup on ,2000 sql server

have to do hotbackup on ,2000 sql server
so that anytime i have 2 sql server; we just write to one server and other as live backup
whats the best strategy ??
20 gb/ 20 user
will distributer/subscirber do the needfule ?
does it need a DTS/SNAp shot versionIt all depends how much you can efford to loose !

There could be

Replication setup
or
Log shipping

Third solution is clustering.

Everything hs its own Plus and Minuses|||can u give me more details
pls|||Clustering is not a hot-standby solution.|||I agree it is not a DB level backup but it provides backup for SQL Server Server itself. For databfiles , there could be SAn with some sort of Raid, Lshipping or whatever. Like I said all depends on wht he is looking for|||Clustering is not a hot-standby solution.Huh? Exactly how much "hotter" can you get than a cluster? When one box in a cluster fails, another takes over without the client even being aware of anything happening.

-PatP|||That's exactly why it's not considered as hot stand-by solution, but rather a fail-over solution.|||If he is referring to a "Hot Backup" as it is in Oracle, he wants to do an online database backup, which is how it is on SQL Server and Sybase. In Oracle, the equivalent requires either:

1. A full export of the database.
2. A hot backup of the database (requires Archive Log Mode to be set on) and tablespaces placed in "begin backup" "copy Datafile" "end backup"

If this is what you want, the "backup database" command is performed while SQL Server and databases are online, there is not need to stop the SQL Server in order to get a database backup.|||Horacle? Who said anything about horacle?|||There is no such thing called "Horacle", but only Oracle - watch your fingers mister :-) JK
Seriously, hot backup in Oracle means it takes one User's tablespace off-line at a time and used the O/S to copy data file(s). For SQL Server 7.0 and 2000, there is no "hot backup" but only a "fuzzy" backup while the database is still online, which some un-commited transactions were not included after the checkpoint.
Clustering is not a pure "Hot backup" either, because if the SAN is went down, there goes your cluster's nodes. Log-Shipping to a standby server is also not a "hot backup" in term of timing, because it take time & manually to switch to the standby server. On other hand, the standby has almost exactly the copy of the production server (except for the very last transaction(s) that hasn't record/backup because of the crash, so in term of the full DB backup & transaction logs backup, the log shipping might be considered a "hot backup" only in this context. The same true is for replication method.|||I think you're confused between "hot/warm standby" and what you came up on-the-fly as "hot backup", which I don't even know where you came up with...

Hot Backup

Someone told me should backup the live data files (files with
extension MDF and LDF) instead of the backup files (file with
extension BAK) in hot backup. I don't think it work in the case I need
to restore these data files from tape backup. Am I correct?That person might be thinking about the various type of snapshot backup products that exists. This
type of backup uses some technique to "freeze" the I/O for some period of time and then use some
journaling to keep track of the modifications performed while the backup is running (while you are
copying the files). There's some information in SQL Server 2005 Books Online, search for instance
for "VSS Writer" (which is the service in SQL server to assist these types of backup programs).
But in general you are right. You don't want to just "grab the database files".
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<viet@.rocketmail.com> wrote in message
news:2341c184-ec8b-42d7-b250-3e5acd594e49@.w8g2000prd.googlegroups.com...
> Someone told me should backup the live data files (files with
> extension MDF and LDF) instead of the backup files (file with
> extension BAK) in hot backup. I don't think it work in the case I need
> to restore these data files from tape backup. Am I correct?|||On Apr 24, 6:47=A0pm, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> That person might be thinking about the various type of snapshot backup pr=oducts that exists. This
> type of backup uses some technique to "freeze" the I/O for some period of =time and then use some
> journaling to keep track of the modifications performed while the backup i=s running (while you are
> copying the files). There's some information in SQL Server 2005 Books Onli=ne, search for instance
> for "VSS Writer" (which is the service in SQL server to assist these types= of backup programs).
> But in general you are right. You don't want to just "grab the database fi=les".
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asph=
ttp://sqlblog.com/blogs/tibor_karaszi
> <v...@.rocketmail.com> wrote in message
> news:2341c184-ec8b-42d7-b250-3e5acd594e49@.w8g2000prd.googlegroups.com...
>
> > Someone told me should backup the live data files (files with
> > extension MDF and LDF) instead of the backup files (file with
> > extension BAK) in hot backup. I don't think it work in the case I need
> > to restore these data files from tape backup. Am I correct... Hide quoted= text -
> - Show quoted text -
If the intention is to backup the database before tape backup . You
can always schedule the db backups online before tape backup and
the .bak files can be backed up on tape.
If the database size is very large you can use the tools like
Litespeed which will help you to save on time.
Thanks
Ajay Rengunthwar
MCTS,MCDBA,MCAD

Hosting DBO Nightmare going Live in 3 Days and counting

My hosting company will give me a user with db_ddlAdmin how do I change my current database which has all the tables,store procedures and views owned by dbo.

I've used a few sql scripts to change the owner using

Exec sp_changeobjectowner 'object', 'user'

and I've used

Grant Execute on object to user

These have changed ownership but the site still doesn't work

Does anyone know what to do to achieve this.

Any help greatly appreciated

Many Thanks

DuncanI hate to tell you, but our hosting operation does give our customers only DDLAdmin rights...

...and they have NO (!) problem creating entries belonging to the dbo user.

It is trivial. Just make sure you create them for the dbo user in the first place (i.e. EXPLICIT).|||Thanks Thona, this seems to set all the tables up fine but when I run dotnetnuke, it has a index out of bound error, I think this is happening because it is not creating any records in the table