A couple of things could be going on here:

1. The backup is not good.

2. You are restoring to a lower version level than the server the backup was taken. Run...

This query should get you what you need:

create table CreateStatus (CreateStatus varchar(256), LastCreate datetime, NextCreate datetime);

go

insert CreateStatus

values ('Busy','2013-09-05 14:42:46.827','2013-09-09 08:40:18.487')

,('Busy','2013-09-09 08:40:18.487','2013-09-09 11:33:27.927')

,('At Lunch','2013-09-09 11:33:27.927','2013-09-09 13:02:27.133')

,('Busy','2013-09-09 13:02:27.133','2013-09-10 14:37:58.107')

,('Busy','2013-09-10 14:37:58.107','2013-09-13 08:41:04.030')

,('At...

A mirrored DB can't be taken offline, so you would have to break the mirror and then recreate it after you are done with the your work. What work are...

I'm not sure what you are asking with this question. If you want a table to list every principal on the server you can use sys.server_principals

You haven't created a default constraint. You have a check constraint (not the same thing). Per BOL sys.default_constraints only returns objects that have a sys.objects.type of 'D'. If you run...

happycat59 (12/2/2013)

---

Full backups and differential backups don't backup data that is in the transaction log. They contains pages that exist in the various .mdf and .ndf files (the data...

Have you checked to see how much space is being used inside your tlog file? If it is all 30GB then you have your answer, but the next question is...

Awesome! Thanks Dan

When you open SSMS just simply provide...

There are some questions that you need to answer first:

1. Why did the Tlog file grow to 2gb

2. What recovery model are you in? Full, Simple or Bulk?

3. If you...

The next time it is in Simple and it can't be truncated I would suggest that you look at the log_reuse_wait_desc column in sys.databases. Here is a link:

http://msdn.microsoft.com/en-us/library/ms345414.aspx

As you can...

Look at the suggestions made by Sean about the design of your tables. Also, make sure that you are using FKs between the two tables. After that you can simply...

I'm still unsure what you are try to do here. Why do you need a single statement? Why not use a transaction to control concurrency? Can you state you problem...

I wouldn't reinvent the wheel. I would use Ola Hallengren's back scripts:

http://ola.hallengren.com/

As far as the how often to run them I would create jobs based on the schedules for the...

If you want to exclude dates of 1900-01-01 then you will need to add:

WHERE ...

AND [LastDate] IS NOT NULL

and [LastDate] <>...