Krasavita (6/17/2009)

---

I am trying to set up system and databases Maintance plan Order and don't know if I need all of it and which order,can some one help me?Thank you

1.CheckDatabaseIntegrity

2.ShrinkDatabase

3.Reorginize...

Well it looks as if someone's put his exam question papers here to be solved ..:-D

http://www.sqlservercentral.com/Forums/Topic738841-146-1.aspx

Well that's lot many questions and each one of them require(perhaps) separate threads.

What is the question here?

2.How many type of mirroring[/quote] If you're running...

you need to figure out what's preventing the log file to be truncated. that you will come to know by seeing log_reuse_wait_descr as suggested by Gail earlier in the thread....

take backup of the log now and then check the used/unused space by firing dbcc loginfo...

to connect to database server from across network from a diff machine, you mention the server name, user id and password in the connectionstring. obviously if there is enough network...

lol, lots of ideas to get last few characters from a string.:-D

JamesNZ (6/20/2009)

---

Thanks Paul, no I'm using Snapshot replication so I don't have a Log Reader Agent.

What else could I check to try and find out how to clear/process this huge...

this site tells you what transactions are not allowing log shrinkage.

http://www.tek-tips.com/faqs.cfm?fid=345

This site tells you on how to forcefully shrink a log file

http://www.broad-lea.com/sql_server/sql_reduce_log_size.html

OR you can click on the link My Posts to view all your posts 🙂

select substring(srcString, charindex(targetString, SrcString),len(srcString)-charindex(targetString, SrcString)+1)

This is a generic statement to be used in place of Right() where srcString is the main string and targetString is the string to be found...

thang_ngo_2002 (6/19/2009)

---

Dear PS

Now I'm also clear:

- No need SQL Enterprise version

- Backup FULL one or more times daily, backup LOG frequency hourly

- Quite same as Oracle Data Guard, but...

thang_ngo_2002 (6/19/2009)

---

Dear PS

Now I'm also clear:

- No need SQL Enterprise version

- Backup FULL one or more times daily, backup LOG frequency hourly

- Quite same as Oracle Data Guard, but...

MothInTheMachine (6/19/2009)

---

I moved it to the production server and ran it. It created the trc file in the direcotry as expected but it s 9kb. Will the trc file only...

thats right. It'll fail 2nd time in this case.

the logic is you restore full backup on the secondary and all transaction logs in sequence in norecovery mode. In log shipping...