To just bring the database out of restoring state (when no restore action is active) you only need to specify this with a restore command:

RESTORE DATABASE [db_name] WITH RECOVERY

Every differential backup stored all modification since the last FULL backup.

Restore actions to bring the database back to Thursday using your strategy:

- Restore FULL backup of last Sunday (with norecovery)

-...

If a database goes into restoring mode it implies a database restore action is started. Run the query below see information about the active backup/restore actions.

SELECT

convert(NVARCHAR(60), db_name(database_id)) AS [database]

,CASE command

WHEN...

those are two different things:

TRUNCATE => delete all rows from a specified table

SHRINK => release unused diskspace within the database file to the OS

Shrinking is not recommended, you...

Allthough the offered solution in the post isn't excactly what you need, you are pointed to the use of "IsNothing". So implementing this in your code it will be something...

Have you tried the solution offered in this post? http://www.sqlservercentral.com/Forums/Topic688467-150-1.aspx

Have you looked at this article (http://www.mssqltips.com/sqlservertip/2578/setup-sql-server-database-mail-to-use-a-gmail-hotmail-yahoo-or-aol-account/) on MSSQLTIPS? It does explain the steps very well and has a list of servers/portnumbers included...

If you have stopped the SQL Server services during install and no locked files were found, you only have to start the SQL service again. If you were not able...

I haven't installed a CU recently, but if I recall correctly all SQL services need to be stopped. During the initial configuration steps a check on locked files is performed,...

The installation of a CU is basically the same as the installation of a SP. Of course: to be sure and on the safe side you should first execute a...

kind of double post...

see http://www.sqlservercentral.com/Forums/Topic1612027-391-1.aspx

Luis Cazares (9/9/2014)

---

HanShi (9/9/2014)

---

And in the worst case scenario you could just turn off and restart the computer (hold the...

And in the worst case scenario you could just turn off and restart the computer (hold the powerbutton for 5+...

It seems to me you are trying to use a tool for a purpose it wasn't built for. This would lead to a lot of customization and programming with a...

winston Smith (8/6/2014)

---

on my sql 2014 server i can execute the following without issue:

EXEC msdb.dbo.sp_set_sqlagent_properties

@email_save_in_sent_folder=1,

@databasemail_profile=N'DB Alert'

[/codel]

On my 2008 R2 server this doesnt work though, and tells me the...