Check out this link, it might be useful:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=142949

george sibbald (2/6/2010)

---

do yourself a big favour, move the master log file back where it was with the data file. Master database has very little log activity being rarely updated...

Ok, So does it mean that you were trying to restore the msdb database to transfer...

olie480 (2/8/2010)

---

I know I wouldn't have a problem with backup and restore if the database (or program) was the same, but in this instance, I have table names that are...

I don't have/do any calculations initially. I would set the log file size as a default size and growth at 10 MB. But as a best practice, I usually analyze...

Sanz (2/8/2010)

---

I have a huge table in my database. I need to delete records from this table. There are no indexes on this table. If I create an index on...

No point in shrinking it up. As advised just restore it normally, if the file has to grow it...

True Gail, completely agree on that. I dint want to complicate him and advised as a possible solution that he'd better has a differential backup during the mid day which...

Woudn't be a better option to restore Full backup then differential which was taken...

ps-490891 (2/7/2010)

---

Hi everyone,

Evreything worked fine till i tried to make changes using:SQL Server Configuration manager and SQL Server Surface Area Configuration (well, in SSIS i couldnt add connection..). Now i...

That's a wrong piece of advise.

But there are places which has only one full backup for a week. take diff....

Why would there be any '+' sign for the installed Linked Server....

Got this issue fixed eventually.

Added a Data Conversion component before loading the data into the OLEDB Destination.

My source columns were Non-Uni(DT_STR) while my OLEDB destination was expecting a output Uni(DT_WSTR)....

Hi All,

Anyone have solution for this?

I am migrating data from SQL Server 2005 to Oracle 10G. I was able to load all large data sets but when it comes to...

tinso-728770 (12/17/2009)

---

One of many of our servers is running SQL 2005 Std Ed. and is emulating SQL 2000 for several databases . The situation raised when one of the user...