Hi Michelle,

In SSMS right click the DB, select Properties then Options - Recovery model is second field from the top.

Cath

Hi,

Yes, the log backup will only free up the space so it can be reused, so you won't see the size of the file decrease. If you want to...

Hi,

Your transaction log is growing to accommodate the large number of transactions, as it's supposed to. Frequent shrinking will cause fragmentation and as the log file grows again it...

Hi JV,

For one thing, the CS in the new collation name means it's case sensitive, so unless all the code in your DBs is totally consistent, you probably will get...

Hi dbrooks,

I've seen the 'not a valid Microsoft Tape format backup set' error when someone tried to restore a SS 2005 backup onto a SS 2000 server. Again, there...

Hi Shevonne,

You should refer your DBA to Matt's response in that case, it's a very clear explanation.

Cath

Hi Shevonne,

You can set the database to the simple recovery model:

ALTER DATABASE MyDB

SET RECOVERY SIMPLE

This will minimally log most operations and truncate the log file on each checkpoint. It...

OP says the assignment requires a subquery, in which case this works:

SELECT e.LastName AS EmpLastName, e.FirstName AS EmpFirstName, s.LastName AS SupLastName, s.Firstname AS SupFirstName

FROM Employees e JOIN Employees s ON...

Hi Pavan,

Braindumps really are not the way to go. Check this link:

http://www.sqlservercentral.com/Forums/Topic406505-10-1.aspx

I'm studying for the 70-431 at the moment, but surely it's better to actually understand the...

Hi,

I've restored master in the scenario you suggest, ie a new server with the old server's name, but never tried to restore to a different named instance, so I don't...

Hi,

You're certainly on the right track. Be sure to build your new server to be as close to the current server as possible - ie same drives, same OS/SPs...

This works too:

SELECT [name] AS Name, dbid AS DBID,

DATABASEPROPERTYEX([name], 'Status')AS DBStatus

FROM master.dbo.sysdatabases

Hi David,

If your secondary server fails and you have the monitor on there, then you won't be notified that logshipping has gone out of synch - unless you have other...

Hi Edwin,

This script will do it: http://www.sqldbatips.com/displaycode.asp?ID=4

Cath

Check these MS links:

http://msdn2.microsoft.com/en-us/library/ms151247.aspx

http://msdn2.microsoft.com/en-us/library/ms190640.aspx

Same info also in BOL