I don't mean multiple file. I mean multiple location like we have functionality in SQL 2005 and later version called mirror backup.

I backed up db on principle server (Full and T-log) and restore in Mirrored db(same server but diff instance) with no recovery.

In Principle Server right click on DB>task>mirror> configured security(...

I am using database mirroring page in GUI.

We have same issue long back because of network load and we implemented same process which you are going to implement.."Backup Db Locally and Copy Backup file to different server".

we...

If you don't have good network latency and 1000 miles distance between servers then Data Mirroring is not good option for you. I am sure what your environment need for...

SQL Server has "db_datareader" role for read access to the database level.

Below is t-sql command and you can also perform this task using GUI.

use mydb

go

exec sp_addrolemember db_datareader, MYUSER

go

Thanks!

what error are you getting???

Check if IP Firewall is blocking your AD Group account??

- it's depends on your environment & your maintenance window. Re indexing is part of maintenance...

Please check the MSDTS, XACT_ABORT (SET XACT_ABORT ON), RPC were configured properly or not.

Read this article, might be it will help you...

http://ask.sqlservercentral.com/questions/17849/facing-msdtc-related-issues-while-archiving-data-from-one-database-server-machine-to-another-database-server-machine-using-windows-service-c

Let us know what you find i...

I have few scripts which we use to script out permissions for database level and server level.

Let me know if you interested in using those script i can provide you...

Hi,

Lite speed backup file has Extension .BKP, If you are doing any upgrade from 2000 or 2005 to 2008 then i suggest you to archive the backup file for some...

If I understood correctly your question then there question is regarding disaster recovery.

Question:-

The server crashed. You cannot access anything. And you are given a new box, what will you...

I had a same problem few months back because one of developer Deleted one DB from our Production Environment. On that server we have SQL 2005 and SP2.

What...

Did you or someone else delete the database from your server recently?

In your SQL Server 2005, can you please check which service pack you have?

Can you please check that maintenance plan history and check all step status......

you may be find something........