It means just what it says....an example will explain better:

RESTORE DATABASE mydb

FROM mydb_backup

WITH NO_RECOVERY

RESTORE LOG mydb

FROM mydblog_backup1

WITH NO_RECOVERY

RESTORE LOG mydb

FROM mydblog_backup2

WITH RECOVERY,

STOPAT = '2004-08-26 12:00:00'

Refer to the BOL for more...

First, the syntax error is that you are missing the FROM.

You CAN have a table alias, but it's how you alias it that can be a problem (you do it...

You say the SQL Server is using Mixed Mode authentication and you are trying to login via Windows login. I can think of two reasons why this might not be...

For once I agree with everyone who wants their point back. Neither a nor b were correct. But in MY opinion b was more correct (because that's the one I...

I understand now, thank you.

You can't view the actual transactions unless you have an application installed that allows you to view the transaction logs. SQL Server doesn't have anything that...

I also suggest doing a search for msforeachdb on this site and maybe google'ing it for more information.

-SQLBill

There is an undocumented stored procedure called sp_msforeachdb. Basically it will execute up to 3 commands for each database.

EXEC sp_msforeachdb 'DBCC CHECKDB(?)'

EXEC sp_msforeachdb @command1 = 'Print "Listing ?"', @command2='USE...

Right click on the icon My Computer. Select Manage. Go to Services. In services find each service for the applications that need to connect to SQL Server. One solution is...

Randy,

To get at your basic question (why does the database grow so big)....it's the transaction log that is growing. When you Reindex or Defrag the index, SQL Server needs to...

When this is occuring, run DBCC INPUTBUFFER(##) in Query Analyzer. Run it in the instance where the databases are being openned. Replace the ## with the SPID (DBCC INPUTBUFFER(74)). That...

First, forgive me - I'm not trying to 'put you down', but your broken english makes it difficult to understand what you want.

Are you asking where the data is located...

Uma,

You've posted in the General topic for the SQL Server Yukon Beta forum. Which is what Jamie was trying to point out.

There are several different General subforums, so be careful...

Add the SET DATEFORMAT command to your script.

SQL Server doesn't know that 12/31/2001 is December 31, 2001. You and I know it can't be anything else, but SQL Server has...

Then it is "depends". My users have Crystal Reports. When they run a query, CR sends the query to SQL Server, which sends ALL of the data back. CR then...

You are missing an = in the second WHERE.

Your WHERE asks for 1, 2, 3, 4, 5 AND 6 months ago.

The other WHERE asks for months LESS than 6 months...