What would you do if the database was corrupted right before your backup? And you didn't catch it before the next transaction log backup was run?

What would happen id...

Chris Metzger (11/21/2011)

---

For example, my trans logs grow regularly. I have SQL backup just the trans logs every 2 hours. Then as part of the maintenance plan (another...

SSIS would be a very simple setup:

You would need a data flow task. in the data flow, you will have an OLEDB Source and an OLEDB destination.

For the source,...

Wow, all these great titles - and all I am is simply the fireman. Well, at least that is all I every seem to to is put out fires.

You can export the SSMS maintenance plans and put them into a BIDS SSIS package. Then, you can modify the connection strings, backup paths, etc... and Save Copy As...

There is a standard report delivered with SSMS call Schema Changes History Report. Run that report and if the information still exists in the default trace it will show...

Perry Whittle (11/18/2011)

---

Most of the organisations I have worked in previously have virtualised SQL servers. Obviously not all SQL Servers are ideal virtualisation candidates, this requires some due diligence.

In my...

I am surprised that an automatic page repair wasn't performed, since this database is mirrored.

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

Gail, any idea on why this wouldn't have fixed the problem already?

Lowell (11/14/2011)

---

something like this?

select [Years] = datediff(year,0,ET-ST)-1,

[Months] ...

You need to work with the Exchange admins to find out why those addresses are blocked. This is not an issue with SQL Server.

I wouldn't recommend removing the system supplied schemas. Since those schemas are owned by the principals associated with them, you would have to modify each principal and define a...

Nadrek (11/10/2011)

---

Personally, if I have the space available, and the index meets my "defrag it" criteria, and I'm within my maintenance window (i.e. I have free reign to lock indexes),...

Simple answer: No...

The credentials you use to login to SQL Server have no bearing on the credentials being used by the backup. The backup will run in the context...

For most systems, I will setup a single domain account per SQL Server instance and run all services under that account.

Only on systems where there is a requirement to make...

Jeff Moden (11/1/2011)

---

For the first question, one supposed advantage of CTE's is if you need to do a self join, you simply refer to the CTE twice instead of writing...