Do you have backup s/w installed on the server?  I recently realized that our copy of Backup Exec was trying to run a backup of our SQL databases nightly.

To answer your second question ... Cascading deletes are not new in sql 20005.  They are available in sql 2000 (maybe even earlier).

If I read your post correctly:

Table 1:  Item Information

Table 2:  Item Identifier + 12 Notes Fields (Note1, Note2, ... Note12)

Why do you need 12 different notes fields in Table 2?  I...

Not sure if you can alias a database name.  However, you can setup aliases for the server name using the SQL Client Network Utility.

You should back it up.  If you use shrinkfile - you are just shrinking the size of a file that could possibly become filled up again and thus putting yourself into...

Are the users machines & db servers set up to talk via the same network protocols?  For example, are the user machines running "named pipes" while the db server is...

Does the directory 'D:\Backup' exist?

Sorry if this is double-posted,  the first time that I clicked "Post Reply" my message seemed to disappear.

What about the advanced properties of the...

If you need to synch up users/logins after a restore, you can:

USE DATABASENAME

go

EXEC sp_change_users_login 'Update_One',...

Thanks for the great editorial, Steve!  It is a shame that a few rotten eggs can spoil the whole basket.  However, it is reassuring to know that there are a...

Daniel:

Have you checked on the SQL server that the "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ArisGame.mdf" file actually exists?  For some reason was the location of this file moved or was this file...

Are you sure in both instances you used the same 2 views in your query?  I know that sometimes a typo on my part can make alot of difference in...

To find out which user account runs the SQL Server and SQL Agent services, do the following on the server:

 Open up the "Services" listing on the server (Not sure why type...

If you are restoring to a different database name OR a different server,:

1.  In the Query...

To answer your question about if you should backup the SQL binary files ... you need to decide what your restore strategy will be.  If your server goes down, will...