Can not restore sql server 2005 Backup

If restoring a .bak file to a new database fails then go to these steps.

Create a new database using this script.

 USE [master]
GO


CREATE DATABASE [Test] ON PRIMARY
( NAME = N'Test', FILENAME = N'C:\Test.mdf' , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'Test_log', FILENAME = N'C:\Test_log.ldf' , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO

Stop sql server service.

then replace the newly created  .mdf & .ldf files with your older .mdf & .ldf files.

Stop sql server service. 

Refresh  your server tree.


Then you are done...

Free Sharepoint Discussion Forums

http://www.sharepointjoel.com/Lists/Posts/Post.aspx?ID=234

http://weblogs.asp.net/soever/archive/2005/03/04/385523.aspx

http://www.datasprings.com/Products/SharePointWebParts/MOSSForums.aspx

http://spforums.codeplex.com/releases/view/53

How to remove the “Title” column from a SharePoint Custom List

Have you asked yourself the question: How do I remove the ‘title column’ from a Sharepoint list? It can be annoying trying to figure out how to remove this column from default lists. Often, site admins want their audiences to click on “New Item” in a Sharepoint list and not have to fill out the default ‘Title’ column content type.


I found a great article while surfing internet.This show you how to remove the
"Title" filed from a custom list

Go to aticle