I'm sure that someone from the DBGhost camp will also respond to this but here we use RedGate SQL Compare, it's cheap, it works and there's a free trial download...

If it were me I'd be looking at detaching the DB and moving it to where you have more space, if existing space is so tight where it is then...

Can you see more than 2GB of memory available to the server?  double-click on the system icon in control panel and let me know what you have available.

Am I right in assuming that your server only has 4 GB or RAM?  If that's the case then you wont be able to use the /PAE switch as that...

I have no idea what HIPAA is, however, the native SQL backup isn't that secure, even with password protection it's fairly easy to get into.

Depending on how you want to...

hmmmm.... something else that i didn't know existed

Cheers Frank

Hi Kishore, you need to double up on the single quotes when you're doing this sort of thing, rewrite what you're doing as follows.

exec ('restore database [hello]

        from disk=...

System performance tuning is so much more than just setting primary keys and away you go.  Other indexes are created because it's more appropriate to use them for certain queries.

If...

Been there, bought the tee-shirt

We've been in production on clustered 64-bit Itanium 2 servers for the last 6 months now and ended up...

None whatsoever, lets call it a MS design feature

I think that I've managed to narrow it down to just 2 possible things that can be wrong (well 3 if neither of these works and I end up having...

Hi Dean,

It's exactly as the error message says, you can't do a transaction log backup on the master database.

It's generally so small that a full backup would complete in seconds...

Hi Bev,

We can't see the error you're getting, can you type it out rather than trying to post a screengrab and we'll see if we can help you.

I wish it was , I left the builtin/admins group there because it's a secure system so this doesn't really apply.

I'm thinking that it's...

Just to clue you in a little on my ongoing saga...

After a couple of days looking I've finally managed to track down the...