At my last company, were told that the new web app was going to be WAMP ... we didn't get to vote. I just took it as an opportunity to...

Detach, move, attach ..... good to go.

How about this ?

Bingo ! Thanks a lot !

Ian Ritchie (10/21/2008)

---

To quickly identify locks use Query Analyser and sp_who or sp_who2

If you have a couple of tables central to the transactions of a couple of users, then the...

Make sure the job is enabled AND that the schedule inside the job is enabled.

As suggested, look at your backup history to see what actually ran and when: For instance, you can run this:

[font="Courier New"]SELECT sysdb.name, bkup.description, bkup.backup_finish_date,

case

when type='D'...

Did you reboot ?

Lester Policarpio (10/12/2008)

---

Thank you for the inputs guys. When I received the error in my server i already checked the drive where in the mdf and ldf is and the...

http://support.microsoft.com/kb/224071

http://www.sqlservercentral.com/articles/Administering/movingsystemdatabasesachecklist/1608/

Do you have a link to any documentation where this has been published as best practice for SQL Server? I would like to review that for myself - since,...

If your FULLs take too long, perhaps do a differential(s) during the day to cut down on the number of transaction logs that would need to be restored.

In SQL 2000, MS said that best practice was to:

- Create a Global Group,

- Put Windows users in the Global Group,

- Put that Global Group in a Local...

Is he asking about pinned tables ?

From BOL 2005

This functionality was introduced for performance in SQL Server version 6.5. DBCC PINTABLE has highly unwanted side-effects. These include the potential to...

I didn't realize you double posted (bad)

Your screen shots look correct. Give the projects a good name. Then test it by restoring your backup to a new database name ......