Better use auto growth in MB rather that %.

Also, see that you have given enough space for the database as auto grow is a costly operation!

Pavan.

Check for any other sort of schedulers like web services etc.

May be if in GUI, you tried something like this!

Login properties-->User Mapping-->Select All Databases-->

Assign the data reader role.

This doesn't work.

If you have 10 databases, then you have to do it...

By Stopping mirrorring you will not be able to see the changes.

To see the changes.

1.Make note of the changes you want to see.

2.Failover the mirroring, now you should see the...

How about trying to create a new named instance using add/remove programs!

Pavan.

Thanks Dan,

This would be helpful sometime or the other.

Pavan.

Something like this it does.

1.It parses the query...checks for the syntax/semantics...checks for existance of tables/views...permissions of users etc.

2.Creates the execution plan, if none exists in the buffer, if exists uses...

did you tick the checkbox saying "Enable this as primary database in a log shipping configuration"

Check if your required SQL Server services are set to start automatically or not, if not modify the properties to set it automatic.

You need to have a shared drive between the 2 servers to set LS.(both the servers should be able to access it, check with permissions)

Place the backed up copy in...

And I prefer it as a multiple of 64 ( 1 extent which is 8 pages (8*8))

Pavan.

could you be more clear.

It looks like you are comparing transaction logs with redo logs of oracle.

They are completely different in the concept.

Its only 1 log file available in SQL Server.

Hope this helps!

Pavan.

Use COALESCE to get rid of null values.

If backing up the file and sending is the prooblem, then use the best ZIP/compressor and then compress the backup file, which may be around 10-20% of your original file.

You...