thang_ngo_2002 (6/18/2009)

---

I want to clone structures of main DB (tables, views, sp, ...not data) to test DB for testing purpose

I use "Generate SQL scripts", but they lack info of Trigger,...

All backup operations in sql 2000 are online unless u're using detach/attach,

Backup database mydb to disk ='my path\my file' backs up the db online while other users can make changes...

also try to run the job as SA and see if the problem relates to privilages of the archive user??

Since the database is put under simple recovery model, i dont...

what do u mean by archive production db? are you taking backup of production db here?

also what is the relation between archive and production db? i cant seem to find...

to set db in single user mode without looping, use this

alter database mydb set single_user with rollback immediate

to set db in multi user mode,use this

alter database mydb set multi_user

still unclear what u need!!

can u post sample data in each tables and expected output.

Yes, this is a better and faster option. Or you...

kishoretukuntla (6/18/2009)

---

hi Thanks for ur reply,

My requirement exactly is, i have a two databases in two different

servers. That servers located one is in my working place(in my office) and...

Also, speak to your network guys on the network fluctuations.

Run this command and give it to the network guys as proof of fluctuation.

c:\> ping xx.xx.xx.xx -t > c:\ping_results.txt

This will create...

also, post failover, try hitting few test queries on the server. If u're able to do that, ur application will be able to do so.

Check connectivity parameters in ur application...

Are you sure you want to use NOLOCK clause in your query. This may give inconsistent results at times 😉

descentflower (6/18/2009)

---

Hi,

I have been receiving below error when i use top(p.nid) in my select.

error:

The reference to column "nid" is not allowed in the argument of the TOP clause. Only references...

well thats a big requirement.

Depending on the level of proficiency ur employer is seeking, they can ask u different types of questions.

However, you must be very good at

1. backup...

kishoretukuntla (6/18/2009)

---

Hi All,

I have a requirement like, I am working with two servers,one is in

intranet(lan or local server) and another server(host server) is in internet.I have to...

He's restoring to the reporting server everyday morning with diff backup...

log shipping would have been a better option...