Look into BOL for the following DBCC commands.

DBCC CHECKDB

DBCC CHECKTABLE

RESTORE VERIFYONLY

Verifies the backup but does not restore the backup. Checks to see that the backup set is complete and that all volumes are readable. However, RESTORE VERIFYONLY does...

The best thing is to restore the backup file to your dev or test server or any server you can possibly with a new name if there is a database...

If the server name has been changed the @@Servername returns the old server name.  Look into BOL for sp_addserver for adding local server.

Good day,

Bulent

2 things need to be happen here.  First item is what Gift Peddie says, your sql server needs to be able to store non-unicode characters and the second is what...

Wonderful, I wish that I told you before.  Thanks for the link Gift Peddie.

Steve, thanks for the tips about SQL 2005 exams.  I have done the same about exam insurance since I failed the 70-228 before with 677 score.  Well I took it...

I would not recommend ExamForce Cram Master either.  Like MeasureUp they are not worth the money.  As I was taking studying I have found errors and send email to them...

if you run EXEC sp_configure you will see the configured value for the fill factor.  But that does not mean that the index was created with default fill factor.  Look...

I would recommend to create/schedule a script on unix system to copy the file to network share that SSIS can access then delete it from the source.

Good day,

Bulent

Just change your source name to the new sql server name.

Good day,

Bulent

I have seen people coming up with all kinds of different job titles.  Look at your job description and what you do day in day out.  then create/post your resume...

while you may find it a little harder to do then using a GUI in SSMS but TSQL is better to this.  I have posted a script that you just...

If you drop the account you know that it's gone and no need to worry about it.  Unless the account needs to be able to login again and they had...

You can change the recovery mode anytime you want or you need.  In this case after you change the recovery mode to full make sure you get a full backup...