I use the backup history data in MSDB to look at database growth over time.

You could copy your backup files to another server or to tape to free up space.

So, you're SQL Management Studio tool on your desktop is running SQL 2005, but you're managing a 2000 database ? Or is your SQL database 2005, but running...

Same with tables, views ... becomes 2nd nature after...

Grant Fritchey (1/21/2010)

---

homebrew01 (1/21/2010)

---

I just looked it up ... Not exactly "down the street"...

I just looked it up ... Not exactly "down the street" from me.

Works for me. I followed the link in his sig and it took...

We've had odd failures like this too. Seems that we get orphaned Excel sessions open on the server, and after too many are left open, DTS packages using Excel fail,...

Why do you put all the data into 1 column ? A little normalization would help.

Yes it is. This one has replies & solutions:

http://www.sqlservercentral.com/Forums/Topic848786-146-1.aspx#bm848943

Is it owned by a schema other than dbo ? If so, it might be at the bottom of the list.

Because the SID is unique and specific to each instance.

Here's an explanation:

http://www.mssqltips.com/tip.asp?tip=1590

Here's an article about fixing the problem

http://support.microsoft.com/kb/918992

SQL 2000 does not run SSIS. SSIS is for 2005 & 2008.

Could you be more clear about what you want to do ?

Can you post the T-SQL for your full backup & t-log backups ?

chandan_jha18 (1/17/2010)

---

Ken Simmons-546488 (5/5/2009)

---

You can't directly restore a 2008 database to 2005, but you can use the generate scripts wizard to restore a 2008 database on 2005. Here is...

Like pin a database ??