Need error message, what stage it is erroring out? are you using script or GUI?

4data (3/11/2010)

---

Hi Jason, thanks for the hint towards the account used to run the services. Both services log on using the Local System Account, which I guess has no password....

4data (3/11/2010)

---

Hi GTR, thanks for your comments. can you tell me how to find if the databases are marked as offline etc using the ssms - as I said before,...

4data (3/11/2010)

---

Hi Andrew, thanks for replying....

Development boxes.... oooh, how I dream of development boxes!!!!

It's a Small business server. No such thing as development boxes in a small business - no...

Is SQL server agent also running? Does these databases marked as offline\suspect\or any other state in SSMS?

I am with Steve on this, If you write script to check for rollup every day, what if t-logs jobs has been failing for whole day and you won't know...

Yes, you cannot attach without primary file group.

This is what i would do

1: Create new database with same objects and schema.

2: If you have BI team ask them to create...

Check whether SQL services is running or not?

Try these steps it should fix.

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

Thats good, Don't always depend on SCOM alerts set up SQL alerts also.

GilaMonster (3/11/2010)

---

Since the question is almost a year and a half old, I'm guessing it's not...

Is user logging into local machine or from remote client? Did you login using SA credentials from remote client or locally?

suresh.maddali (12/18/2008)

---

Pradeep provides Good links but my problem is not solved.......

One Thing:

My .mdf, .log file names are

wowzzytest.mdf, wowzzytest.log files, error occured like

wowzzytest is not online, but when...

Yes, you wanted to do it manually right?:-D

conor.devlin (3/11/2010)

---

Hi,

I would like to implement log shipping between our OLTP database which is SQL Server 2005 and a reporting database which is SQL Server 2008. Is this possible? ...

http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en