This is also good start to find the Corruption

Help, my database is corrupt. Now what?[/url]

Yep,

http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/

http://www.sqlskills.com/pastConferences.asp

If its one table , Then write a script and automate it.

Yes its 700.Two weeks back i had that exam.

i got 1000:-)

hemadribabu (11/12/2010)

---

I have to move 1 table , its size is 700 MB, the movement should take place from production to reporting server, on daily basis. I need this to...

Roust_m (11/11/2010)

---

Well, I've tested it. I've created a new database with an empty compressed table and did an insert of 1GB of data. The data file went up...

Thats already suggested by gail.

hemadribabu (11/11/2010)

---

Hi

sql 2005

I have to take a Backup of a table from prod instance and restore the same in Reporting instance.

this process should be automated, kindly tell me...

MostInterestingMan (11/11/2010)

---

GilaMonster (11/11/2010)

---

Was this DB restored...

Did you add sql server account to Lock Pages in Memory ?

c.ajitkumar (11/11/2010)

---

yeah we have memory pressure but i am not able to understand some thing

when i executed ur query i got the same value for total memory and target memory...

saidapur_satish (11/11/2010)

---

Hi Ali,

1+TB data means not a jock..........

If you give the full backup means take too much time & also that time your server is...

c.ajitkumar (11/11/2010)

---

hi

thanks for replying

in my scenario i have 64 GB of RAM and i set the min memory =1GB and max Memory 45 GB

but when server is busy...

The answer is "It depends"

Its...

Also i have recommended to read the Kimberly's(KT) link

Instant Initialization - What, Why and How?