But openquery needs linkedserver. This is not what I want.

I have a database is over 0.5 TB after 2.5 years. If the business has no need to keep the old data, whether we can move the related contents...

Seems 'archive' attribute is the one to work on.

"if you back up the files to tape, the tape archive application uses the 'archive' attribute to determine which files need to...

I am also interested in this topic.

"...I recall that one way you can check whether or not your flat .bak file has been backed up or not is file properties...

Thank you all. Very good resources. I get more than I expected.

and :w00t face does not work 😀

I'd better leave here.

Lose 6 points for this QoD. I consider this as a bad luck :w00t

Steve, have you backed up SSC 😉

Log shipping (if you mean SQL Server Log Shipping) is configured to ship log from one SQL Server (or virtual SQL Server) to another SQL Server (or virtual SQL Server)....

MP (6/12/2008)

---

Hi Carolyn,

I still can't get the deadlock to show up in the log. I added the new alert that you mentioned and I added the notify operator as...

Thank you. That is exactly what I need. I remember something related to trace flags but did not know which trace and how.

one more, change double quotes " to single quote ' if I remember correctly.

Seems a lot of work to do for this. A couple things for now:

1. Upgrade SQL6.5 to SQL2000 first, then upgrade SQL2000 to SQL2005. You may encounter...

To continue the list, here are the options

S: for Server

V: for Virtual Server

3: for windows 2003; 4 for windows 2008

Environment: PRD/QA/DEV

LOB – Line of business or application: MIS, MKT (marketing)

Loc...

That is a good idea. Here is my part:

http://technet.microsoft.com/en-us/library/ms143695.aspx (before/after the migration)

and enable DAC.

Yes. Either one works fine up to version SQL2008. Unless system databases have changes after SQL2008.