I concur with Robert that regardless of version, backup and restore is usually the best and fastest way to go.  One thing that may save you some time is to...

Is this SQL Server 7 or 2000?  If it's 7 and you copied using the wizard, there are known problems with this.  A better and probably faster option is to...

If it's a question of just wanting the DB to remain static, why not just use the Read-Only option and remove any user access?  The Read-Only attribute will persist after...

It depends on your server hardware.  Just kidding , but hardware an RAM definitely has an impact.  Dont' know if this helps you or...

From the title bar have you tried My Account, My Recent Posts?  Hope this helps.  You can also 'watch' a topic by checking the box at the bottom when you...

Government waste is bad enough.  But you would think that at least the confidential information that we submit to the IRS (Internal Revenue Service in the US) is secure, right? 

Think...

LOL...  I'm going to see if I can get a government grant to support development of my 'silly walk'. 

LOL...when I was a kid I remember many times when Dad was asked what we did while we were on vacation, he would quip "Oh, we went to Washington to...

I'm a bit confused although I got this one right.   Can someone please tell me where Mobile edition fits in here?  Thanks in advance.  ...

Glad that helped.  And I'm glad that Microsoft finally did away with this in SQL 2000.  I've seen more than a few people who got concerned when they saw the...

Are you using SQL Server version 7.0 utilities?  In this version, the red line over the green arrow simply indicated that you have a valid connection to the server.  If the...

Correct me if I'm wrong please, but if you change the registry value to only keep only one log file, then restart SQL Server, won't you lose the previous log...

Agreed that there are some excellent scripts on this site for doing this.  Check BOL on the subject of the sqldiag.exe utility that ships with SQL Server 2000 and is a...

In case anyone is interested, there's a contradiction in BOL about this topic.

If you look up the subject "Named Pipes Client Connections" it states that "The makepipe and readpipe utilities are...

We've had similar problems using another product (Legato) where for whatever reason, the backup process gets hung.  Like Rudy, we don't shut down SQL Server or native backups during the...