Do you know what file(s) is using the space? Is this strictly the data file that grew or is the log file a part of the size that you are...

Really the steps are fairly simple with one complexity that you want to ensure you have something in place to work around. So, a brief outline as follows;

1. Configure...

A couple of quick thoughts, MS may not support replication of the database in relation to their application but you are only doing this for reporting so, you could set...

hemant789 (2/4/2009)

---

Thanks for your reply.

So what I have to refer dump file which is created in the SQL server Log directory or sql error log from enterprise manager/management studio?

After the...

Just glad that you were able to get the instance back up. 😉

...because someone changed them 🙂

How about with sqlservr.exe -m? Still seems to be a permissions issue though based on the errors but we do know how those are sometimes. 🙁

Does your command look something like this?

sqlservr.exe -d F:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf -l F:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG

The last location should match your error log...

SA (2/4/2009)

---

2009-02-04 13:22:49.60 spid4s SQL Server started in single-user mode. This an informational message only. No user action is required.

2009-02-04 13:22:49.60 spid4s ...

SA (2/4/2009)

---

I recently built a 2-node SQL Server 2005 cluster. One of the support guys deleted the tempdb database (along with the parent folder), which was on its own drive.

Obviously,...

Have you recreated the folder where TempDB should reside? Do this first if not and post back with information. Thanks.

Lynn Pettis (2/4/2009)

---

Oh, I may as well extend that I shouldn't be a DBA because I have no knowledge regarding replication. Yes, I set it up once years and...

Yeah, the only way to truly offload all the loading performance impact would be to do it on another server and copy the newly loaded database (Options 1 and 2)...

Mike Levan (2/4/2009)

---

I need more clarification on the following

1. Can the staging table and production table be on different servers/databases and how does that if effect perofrmance with different servers.

2....

Michael Earl (2/4/2009)

---

I'll add to this...

To me, "INSTEAD OF" triggers always feel like "INSTEAD OF DOING IT CORRECTLY" triggers. They are great for a stop-gap when you need to...