you can use the following process:

* backup/restore

* deattach/attach

Yes you are right.

Point in time recovery is not possible when the DB is in Bulk Logged RM and also if a bulk operation existed. In this case just...

Hello,

1. the statement is just a statment or is a set of those?

2. It is possible to check if when the query is executed manually ALWAYS is excuted quickly and...

Hello,

Check the following document, there is a section (I/O Bottlenecks) which explain your question.

http://download.microsoft.com/download/1/3/4/134644fd-05ad-4ee8-8b5a-0aed1c18a31e/TShootPerfProbs.doc

Regards,

Hello Ratheesh.K.Nair,

Is important to be aware that when SQL Server is in Bulk logged RM logged in minimum way the Bulk operations, it means, SELECT INTO, BCP, BULK INTO....

Hello ,

The stored procedure use 2 table . StudentTemp and _Student, would be possible to attach the definition for the both tables ?,

with regards,

Hello,

I feel a dejavu!!!, the same answer for almost the same question.

You can backup / restore your database to / from share folder, just defining the UNC name on...

Hello,

I would like to know exactly what do you want to do...

with the information that you share with us i can tell you the following, You can backup...

defrag your indexes yes.

YouDB->Tables->Indexes-> right click there are option rebuilds.

Hello ALIF,

You can backup / restore your database to / from share folder, just defining the UNC name on the BACKUP/RESTORE statement.

The BOL said:

If you are using a network...

Hello,

to work with ERROLOG you can check the following links:

http://sqlpost.blogspot.com/2009/07/sql-server-working-with-errorlog.html

http://sqlpost.blogspot.com/2009/07/sql-server-sql-tips-select-errolog.html

In the other hand, you can check with windows explorer the default path where the errolog files are located:

C:\Program Files\Microsoft...

How to move log files in details

http://www.mssqltips.com/tip.asp?tip=1774

Hello Rambilla4,

Please check this post.

http://www.sqlservercentral.com/Forums/FindPost307316.aspx

Regards,

Hello,

A replication could be a solution, but, you do not mention nothing about the amount of the tables to be copied. If the amount of table is huge, replication...

Hello Kirit,

The suscribers with problems are 2008 or 2005?, what about the OS version?

For security you can change the user, and use a domain\account instead of sa, is necessary...