The SQL is dynamically created due to changing filegroups/files. Essentially, it's:

DROP DATABASE olap_snap

--auto-gen the actual files here via sys.database_files--

CREATE DATABASE olap_snap ON

(Name = [fliename], FILENAME = 'k:\snapshots\filename.snp'),

(Name...

Retroactively, probably not. There's a very slim chance that you might possibly find a shred of evidence in the transaction logs.

Proactively:

set up a Profiler trace or an On Delete...

1) There are some "best practices" articles on this site regarding migration. I suggest you take a look at them.

2) Make sure your logins, jobs, etc. (i.e. the things...

Here's the article I was talking about:

http://msdn2.microsoft.com/en-us/library/ms345235.aspx

Here's another ref to look at:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=83229&SiteID=1

We just went through this on 2K5. The only problem area is Reporting Services. If you've got that running there's a few manual edits you'll have to do....

I VPN all the time without issues. However, I VPN then RDC and run the processes on the server. Running things over a network (especially backup-related things) have...

Full text catalogs cannot be backed up on 2000. You'll have to recreate it after you have restored the database. Make sure you test everything first, though.

This is great:

http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx

There's also lots of good info here:

http://technet.microsoft.com/en-us/sqlserver/bb331794.aspx

and

http://www.sql-server-performance.com

I'll respectfully disagree with GSquared. If the queries run do a lot of disk I/O then having disks at near-capacity can indeed impact performance. That's not to mention...

Unless you have a secondary file set up (an ndf file by default) as the default file*, the mdf file is where all the data is stored. That means...

Clients that listen to my advice the first time around and a raise to help pay for all the home renovations we have planned.

Saner commutes would be terrific, too. ...

Here's my basics:

Write a "notification" time into the contract.

Bill enough to account for a week or two of down time and make sure you set money aside.

Regarding the taxes, there...

Best Practices links I have bookmarked:

http://technet.microsoft.com/en-us/sqlserver/bb331794.aspx

http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx

http://www.simple-talk.com/sql/database-administration/ten-common-database-design-mistakes/

http://www.datamodel.org/NormalizationRules.html

http://www.sql-server-performance.com/articles/dev/sql_best_practices_p1.aspx

http://www.sqlskills.com/blogs/paul/CategoryView,category,DBCC.aspx

I know about the GUI - use it all the time. However, in this case I have 916 out of 3200+ tables to script. That's a lot of...