Do I need to do anything with schema or user login or just restore will work?

Thanks

Hi,

I am also using local instance which ones on VM.

I have also moved TCP before named pipes in the protocol order list.

When I am starting up Sql Agent from Sql...

Thanks again.

I have already enabled - named pipes too, I was just checking osql -L and sqlcmd -L to see.

Thanks,

Sorry as I have posted in a 2008 forum but we have Sql Server 2005 and 2005 SSMS.

I have tried both Sql server and Windows.

I couldn't login so unable...

Thanks Gail.

Thanks Dave. I have down loaded ClearTrace Trace tool on my local m/c and I will run Trace tomorrow on my production server and import that trace file into...

Thanks George, I have changed the Log Backup Frequency to one hour.

I ran again DBCC SQLPERF(LogSpace) and it shows around 14 GB but I was looking Backup Log on...

Thanks once again.

I have changed log backup frequency to every hour and

I was looking log backup size on my backup drive and it shows for each hour after changing:

8...

Thanks George.

I don't know but now it show from DBCC SQLPERF(LogSpace)

Log Size (MB)Log Space Used (%) Status

14198.8 ...

Thanks George.

Basically the size should be enough to handle your largest amount of log activity between log backups, so if your largest log backup is a couple of GB say,...

Thanks Gail and George, appreciate your valuable tips.

I read that link and it has very useful information about T-log. I am just little confuse about setting up log size.

Is it...

Thanks George.

I agreed with you for the first one not to shrink frequently.

I can set up the log back up hourly instead of every two hrs.

Now when you say "...

Thanks.

Actually i am looking for Database Growth so i can verify that how the growth is going everyday or weekly basis by captuiring timestamp and Datafile, Index size.

Thanks.

Hi,

This is a nice script but how can i set up as daily job and capture the output in a file?

Declare @sql Nvarchar(MAX)

Set @sql = N''

Select...

Hello,

If anyone has idea?