I don't know if this will work with a database that is being restored by replication, but...

when a database is restored using WITH NORECOVERY, it will be stuck in LOADING...

This usually works for me....detach the database and then re-attach it.

Then once it is successfully attached, BACK IT UP.

-SQLBill

<quote>every time the first job runs it logs the following error message:

18278 : Database log truncated: Database: SERVICECENTERMAPPED.<end quote>

Okay, what's the problem?  Your first job is to TRUNCATE THE DATABASE...

A sample of your data would help, but I'm guessing that your original column has letters or other non-numeric values in it.

-SQLBill

It sounds like you are trying to RESTORE Fullbackup, then a DIFF backup and then another DIFF backup. You can only restore one Differential to a Full backup.  Since the...

The #1 most important thing to know before you upgrade to SP4...

Does your vendor support it?  If the database is created via a vendor application, upgrading to SP4 may 'break'...

Basically, you are 'fooling' your SQL Server 2000 into thinking it's a SQL Server 7 system.  The purpose is to allow SQL Server 7 functionality to still work.

-SQLBill

I have a server that has 4 1GB processors and has a 205+GB database on a SAN.

It can take 15 - 20 minutes to come up.  That's normal for the...

I backup to disk and then copy those files to tape.  Sometimes I have seen the error you are getting.  When it happens, it's usually because my 'copy to tape'...

Look up DBCC SHRINKDATABASE and DBCC SHRINKFILE in the BOL.

Then use one of those commands (I prefer the shrinkfile) in a scheduled job.

-SQLBill

Is the maintenance plan creating a new backup file each time it runs?

I don't use maintenance plans and script my own backup jobs, but this is what I have seen...

Oh, most importantly...shake your boss's hand and tell him THANK YOU.  Most bosses demand system admin privileges, even though they don't need it and it's a bad idea - they...

Create a login for him using Windows Authentication.  Assign him an appropriate default database (the one he will use the most).  Assign him access to that database and DATAREADER only.

The...

There is an undocumented stored procedure called sp_MSForEachDB (there is also one for tables called sp_MSForEachTable). That procedure lets you run a script against ALL databases (or tables).

The syntax has...

Yelena is actually correct.  I misread the post (even though I quoted it). What I meant was, if you can PING by IP, then it's probably Name Resolution problems and...