Problems with the VS2005 IDE

I have installed VS2005 MSDN-final, SQL2005, SQL2005 EXPRESS

The problems I have are two

1. I can't add a new sql Database to my windows project due to an error about not being able to start a user instance

2. After I create a new database in SQLExpress, then the datasources window doesnot show the datasource I have created when if form designer view
Any suggestions please

SQLExpress instances must be referenced using its named instance localhost\SQLEXPRESS. If you are doing that then your ok.

Also, make sure the sql services are started.

The datasources window probably only shows you database information that you have configured it for. You would most like have to create a new datasource to see the other database. The datasources is not like the Server Explorer in VS.NET 2003

-HTH|||What I meant Is that the datasources window is disabled when IDE loads the form view designer

problems when backup transaction log

I have a problem when backing up the transaction log
the server seems to freeze and other processes on the
server are stopped due to a timeout or locking
my question is what is happening behind when
I backup the transaction log , things that can have an
affect on our other applications run on the same server
10x in advance
ranBOL says:
Transaction Log file is the serial record all transactions that perfomed
against database since since the transaction log was last backed up.With
transaction log backups, you can recover the database to a specific point in
time (for example, prior to entering unwanted data), or to the point of
failure.
Transaction log backup removes all inactive portions of transaction log (
comitted transactions which has written to the disk )
It allows to keep transaction log with acceptable size by resusing its
virtual logs.
"ranm" <ranm@.dec-op.com> wrote in message
news:430f01c3febc$b2be7980$a301280a@.phx.gbl...
> I have a problem when backing up the transaction log
> the server seems to freeze and other processes on the
> server are stopped due to a timeout or locking
> my question is what is happening behind when
> I backup the transaction log , things that can have an
> affect on our other applications run on the same server
> 10x in advance
> ran

problems when backup transaction log

I have a problem when backing up the transaction log
the server seems to freeze and other processes on the
server are stopped due to a timeout or locking
my question is what is happening behind when
I backup the transaction log , things that can have an
affect on our other applications run on the same server
10x in advance
ranBOL says:
Transaction Log file is the serial record all transactions that perfomed
against database since since the transaction log was last backed up.With
transaction log backups, you can recover the database to a specific point in
time (for example, prior to entering unwanted data), or to the point of
failure.
--
Transaction log backup removes all inactive portions of transaction log (
comitted transactions which has written to the disk )
It allows to keep transaction log with acceptable size by resusing its
virtual logs.
"ranm" <ranm@.dec-op.com> wrote in message
news:430f01c3febc$b2be7980$a301280a@.phx.gbl...
> I have a problem when backing up the transaction log
> the server seems to freeze and other processes on the
> server are stopped due to a timeout or locking
> my question is what is happening behind when
> I backup the transaction log , things that can have an
> affect on our other applications run on the same server
> 10x in advance
> ran