Our logs are located on very fast San disk pools with 146g and solid state. The backups are on 600g san drives and then moved to tape. Depending...

We run log backups ever hr at most on large system. Some of our large heavy transaction databases are every 30 minutes. Those even have a total of...

Thank you very much.

I am looking a deeper understanding, you are providing that.

I will do some experimenting. I will change one of our test system we can do...

I know, but there are 10's or hundreds of processes, SQL only writes 1 at a time to a log file. Also, I have 4 log files on a...

http://groups.google.com/group/microsoft.public.sqlserver.security/browse_thread/thread/4d9ce4133f04eb71/4e30b0b80e001799?hl=en&lnk=raot#4e30b0b80e001799

and

http://blogs.msdn.com/b/sql_protocols/archive/2005/11/10/491563.aspx

Both state that the SQL Server 2005 and 2008 by default encrypt the login and password.

I was trying to find a link to a MS /...

How bid is your company? How many DBAs?

We are a large company. We have 1500 instances on 1200 servers/vm guests. We have 3 dba. Right now...

SELECT OBJECT_NAME(S.[OBJECT_ID]) AS [OBJECT NAME],

I.[NAME] AS [INDEX NAME],

USER_SEEKS,...

Not the solution I was looking for, but found one that worked.

From a script on the server, I found a username/pwd for SQL. It had next to no rights....

I got the database up and running. The problem is we bought out a company, who bought out a company, who used to own this system. Built in...

There are 4 sockets in a Dell r900. We use quite a few of them, very nice machines.

I started taking a look at the link last night. There...

I wish they were supplying the license.

That's my rub in this. Because of vendor control, I can not implement the Enterprise features.

Thank you for the link, I will check...

Ok, there is schtasks that allows scripting of the backup schedules.

I can use SMS to send out in stall the software and scripts.

Still, if anyone has this type of enviroment,...

Thank you, I have started to test this and it seems to be the best path. I am working through the script on the develpment box right now.

Joseph

Thanks for the info.

I had thought of inserting, but just 1 table took a very long time.

I had not thought of the indentiy column. I will give...

thank you for your reposne.

I did now about the pk/unique clustered index. I have a problem in creating on with the content of the tables. To get a...