from memory you use the logical filename in move

RESTORE DATABASE [testdb]

FROM DISK = N'\\serverA\c$\sqlbackups\testdb.bak'

WITH FILE = 1,

MOVE N'testdb_Data' TO N'E:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\testdb_Data.mdf',

MOVE N'testdb_Log' TO N'E:\Program...

I would only consider spliiting up to different filegroups if you have exhausted other performance tuning options and if there is a noticable I/O bottleneck. Filegroups are not a...

It does seem the norm for BI jobs that I have worked at, cubes are usually built within a couple of days and up to a week when...

yes playing around with the registry can destroy an OS and any application that uses the registry.

I am doing it at the moment, used BOL as above , I couldn't find any specific books for it but I am sure some will be out soon..

you really need to do a log backup

have a read of this

http://www.sqlservercentral.com/articles/64582/

Setup a maintaince plan to do a cleanup of t-log backups older than 1 day.

Also you need to ensure that any application that connects to the principal database is made mirror-aware. You can do this in .NET by using FAILOVER PARTNER in the...

you could cast the datetime to time for the where clause

where cast(start_date as time) = '00:00:00.0000000'

If the app server is a windows based server then you will be able too.

Safety of it depends on how you configure the security.

The pros are you will have...

If by log you mean changes, then for structure changes you can look at the default trace (if its running)

http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/

for data changes you need to build that in...

Robert Frasca (9/3/2010)

---

steveb. (9/3/2010)

---

The trasanction log should not* affect the performance of the server.

Take regular t-log backups to manage you t-log and provide PIT restores.

for the performance issue you...

It depends on what sort of mirroring you have setup, I would leave the thressholds alone unless you are experincing issues.

One important thing to consider after implementing mirroring is...

The trasanction log should not* affect the performance of the server.

Take regular t-log backups to manage you t-log and provide PIT restores.

for the performance issue you need to look at...

try using datediff to get the number of days between @start and the birthday

If it is between 0 and 7incl then their birthday is in the next 7 days

Where...