SQL Server will work without a network. It's like standalone server. But you can't connect to it. If your company has a dial up number, you can get in to...

Did you transfer any data recently into your prod from some other server? If yes make sure you check the proper check box. It will ask you drop and re...

That’s correct, you are no longer in the Network.

Make sure your sql server agent is a dependent on SQL Server

Use the following SP to compare structure and data in two databases

CREATE PROC sp_CompareDB

@db1 varchar(128),

@db2 varchar(128),

@OnlyStructure bit = 0,

@TabList varchar(8000) = '',

@NumbToShow int = 10,

@NoTimestamp bit = 0,

@VerboseLevel tinyint =...

Yes

Well if you want to generate a report then write a procedure to select the data from a dummy table in your userdb. If the select fails either the database...

When you import the data into the DB, both the log file and data file will grow. You need to shrink them manually. Btw if your table considerably big, its...

Did you tried running with the standard login? If not I would start with this

Before SQL Servers stops completely it will log a message both in to SQL Server Error log and OS Eventlogs, Works the same way when you start the sql server....

Select name, enabled, Description, Date_created, Date_modified from msdb..sysjobs

There is no SQL 7.5. I guess you are referring to 6.5. Here is a link to Converting Databases to Microsoft SQL Server 7.0

http://support.microsoft.com/default.aspx?scid=%2fsupport%2fsql%2fcontent%2f70papers%2fconvert.asp

Good idea if you are using Backup device. We usually backup to the Disk to Tape

I agree with you, but that’s the only safe solution from MS. Hope they will add a trick in the next Ver 🙂

http://support.microsoft.com/default.aspx?scid=kb;en-us;319664