John,

Could you please post the error for the same.

sp_resetstatus against the database to bring that online.

If you have auto-close option set to on then the database will be closed after the last user disconnects the connection to the database. After that when a new user...

In that case what the previous caller says is right. One thing that strikes me is to do a check everyday for the integrity of your datastrucutre and mail to...

You will need to have both the source and destination server registered in the same enterprise manager to configure logshipping thats the reason it points to the server list that...

Amanda,

Since you have now restored the primary database you will need to reconfigure the logshipping again. Yo can delete the old jobs running for it. Also if you have any...

Yes each instance will have its own copy of master, model, msdb and tempdb database. Those can't be shared with other instances.

Derek,

Since you say that you are new i prefer you to follow the second method of doing a side by side upgrade than a inplace upgrade since that involves lot...

Zafar,

The link given below will solve your problem.

http://technet.microsoft.com/en-us/library/ms178083.aspx

Btw deepak the link you have posted is to change the server name in a stand alone machine and not in a...

To add more this chain, Read more on Differentialchange map and bulk change map in BOL to know how sql server backs up the database and log files.

Check the properties of the database the file group would be having restricted growth change the setting to unlimited file growth and give growth by MBs instead of percentage to...

Do you have recent Service Packs installed. This morning i read an article in another website saying that there were lot of bugs with SSMS in RTM and they ar...

you can use sp_change_users_login 'report' for each database to check if the user is a orphaned user in SQL Server.

From yu query it looks like you have the current database running the the secondary server. You take a full backup of the secondary database and restore in the primary...

So it is as easy all that you wanted is the user should not use the database from the backend and use only the application for anything. As said change...