Jake, the sp_help_revlogin will bring passwords across. straight to 2008. I have done it myself many times.

Perry, master.sys.sql_logins is not available in SQL2000 so Jake will not be able...

Jake Shelton (4/10/2014)

---

george sibbald (4/9/2014)

---

your question said transfer from sql2000 (2K) to sql2008 (2K8), is that correct?

SQL IDs are logins authenticated by SQL, i.e. you enter an ID and a...

your question said transfer from sql2000 (2K) to sql2008 (2K8), is that correct?

SQL IDs are logins authenticated by SQL, i.e. you enter an ID and a password, rather than windows...

I have not tried this so cannot confirm it it works. Even if it does I can say it would randomize SQL authenticated passwords, so it would be of no...

damn this slow network!

find the trace ID (1 is normally the default trace, you can confirm which is yours from where the output is going to)

--check trace status

SELECT * FROM :: fn_trace_getinfo(default)

--stop...

backup compression is not compatible with TDE.

you can enable it but will get very little if any compression.

Erland Sommarskog (4/2/2014)

---

If there is no record of the successful login from the intruder, it is difficult to track.

But unless sa had a blank password or something else guess at...

yes, it requires a SQL (not server) restart to enable it. If this is 64bit probably not set or required but it can be, especially if you see messages about...

I am sure you have already thought of it, but change the sa password or disable sa, turn off xp_cmdshell if you don't need it. By having sysadmin rights they...

It depends. SQL might not give up any memory until the OS requests it, if you have lock pages in memory set SQL won't give it up.

You may have to...

you can do that but its not going to help, log growth will be the same.

You need to break the delete up into smaller transactions.

for all databases except master,model,msdb, the databases should be presized so autogrowths are avoided, this is very important on tempdb.

Having said that, for all databases except master and model (so...

Ed Wagner (3/31/2014)

---

I've found the creation of a script and then restoring from a production backup to be very reliable.

ScottPletcher (3/31/2014)

---

Of course, if it's possible, it's much easier longer-term to...

New Born DBA (3/31/2014)

---

I did run into some problems and I am wondering if someone can tell me what to do.

I was unable to restore the DB because the DB...