thanks. We are decided to go for 13GB as Max memory and adding Domain account in lock pages in memory.

But what about the Min value for Memory? Can we keep...

Yes, only one instance of SQL server is running

Hi Gail,

We have windows 2003 EE R2 x64 with SP2 and SQL Server 2005 EE x64 with SP2.

We have 16GB RAM.In Our SQL Server instance sharepoint Application databases are sitting....

Thank you

My question is that are there any issues and special considerations as we are moving databases from higher edition(Enterprise evaluation) to Developer edition?

plz suggest me

Hi Steve,

Actually it is Active\Active clustered Sql server 2005 Environment. But in that I installed one Sql server 2000 instance as a normal installation(not clustered). In that instance Iam trying...

Thanks Manu...

The steps:

1.net stop MSSQL$ins

2.cd C:\Program Files (x86)\Microsoft SQL Server\MSSQL$ins\Binn

3.sqlservr.exe -m -s ins( Normally How much time this step will take?)

4.Open Enterprise Manager

5.Query analyzer. Here Iam getting the...

Yes Manu, Iam restoring the Master databse from the current backup

Thanks Lynn,

I have followed the below steps:

From the command prompt

1.net stop MSSQL$ins

2.cd C:\Program Files (x86)\Microsoft SQL Server\MSSQL$ins\Binn

3.sqlservr.exe -m -s ins

here I got the below message:

2008-11-24 14:01:48.96 server ...

Thank You Makus,

Iam able get to the step 4. After step 4 Iam getting the error

microsoft sql-DMO(ODBC SQLState 01000) the master database has been successfully restored.shuting down sql server...

Hi Deepali,

could you pls explian me how to connect to sqlcmd after starting the sql server instance in single user mode

Thanks

Thank you..

is there any sample restore script to restore from backup device(which consists full,diff and log backups),that automatically takes the file numbers and restores the database.

OR do we need to...

Thank you..

I understood as below,plz correct me if Iam wrong.

1.when ever we want restore a database backup from a backup device(which consists full,diff and log backups) we need to go...

How did you find these file numbers:

-- now restore the closest differential

Restore Database ABC from abc with norecovery, file = 25 -- I think this would be the 5 am...

thank you Corbett...

I executed the command restore filelistonly from backupdevice, Iam getting the below results

LogicalName PhisicalName ...

thank You

we have full backup at 11:00pm and diff at every 6 hrs and log every 15 mins. All backups are going one backup device ABC.bak.

If a database 'ABC' crashed...