Hi,

1. Take backup of your databases.

2. Detach your database after closing all active connections

3. Attach the database using SSMS.

4. Delete the log file that's not required from the db...

Hi,

You can create a SSIS package using BIDS.

1. Create two data flow tasks

2. Data flow Task 1 will have OLE DB source, Data converter and excel destination(For groupA)

3. ...

Hi,

Yes it shows that it might be insufficient on memory.

but decisions cannot be taken on only one counter alone.

you might also have to check counters like available bytes/sec, %usage for...

You can try above two things:

1. Reboot the windows server

2. check permissions for agent service. check if it has required permissions to log on.

Litespeed is a good backup tool

Hi,

In our environment all backups and restore are handled by DBAs.

so, you should not be handling any permissions to the any for backup.

If this is a scheduled backup then you...

Hi,

Rebuilds and update statistics need to be done frequently.

This takes care of fragmentation on indexes and in my environment did result in faster data access.

It did make the report generation...

Hi,

It cannot be done.

Even if you are able to read by some codes, it wont be legible.

It could be like #@!@@#$$#

Thanks

Satyen

Yes..you can. Under SQL Instance, go into Logins.

On the domain account right click on it and select permissions.

go to User Mapping, select only those databases that it needs access to...