- Win. (4/14/2010)

---

Thanks Pradeep Singh,

RESTORE DATABASE [AMBD_NEW]

FROM DISK = N'\\AMBD\DBBackups\AMBD.bak'

WITH FILE = 1,

MOVE N'AMBD_new.mdf' TO N'E:\Data\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\AMBD_NEW.mdf',

MOVE N'AMBD_new_log.ldf' TO N'E:\Data\Microsoft SQL...

THE-FHA (4/14/2010)

---

And if the backup files that needs to be deleted are more than one and all of them are named using the instance_name and date, how will you go...

d.srikanth50 (4/13/2010)

---

friends one production database performance is slow.we have kept that recover model is in simple.if we can modify to full log file reaching its limit.

please guide me how to...

Yes it will automatically failover. However, since this is a...

You dont remember your instance name and database name?

for database names,...

Read about Backup Database from BOL. You'll get help on how to backup a database.

DEV server : The...

You should analyze queries which...

You can also consider using LiteSpeed as your backup/restore tool..

The query that Perry gave...

Can you post table structure and sample data?

This site will help you in posting the same.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Go through these articles written by Gail Shaw n u'll get a fair idea on how to deal with slowness.

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

You can add an article to an existing publication.

Refer :

http://deepakrangarajan.blogspot.com/2009/01/sql-2005-transaction-replication-adding.html

igngua (4/13/2010)

---

Hi Guys!

scenario;

col1 col2

ID1 datetime1

ID1 datetime2

ID2 datetime3

ID2 datetime4

I...

try selecting windows authentication and login to the system. If you have not removed builtin\administrators(it's present by default), you'll be able to login using ur windows login..

Jacob Golden (4/12/2010)

---

There are 6 call centers and each of them has an identical server that houses their own data that is replicated to the main server each night currently....