You might want to look at third party backup tools which will reduce your backup window. Red Gate (who I work for) have a product called SQL Backup which...

Hi,

The first thing you need to do is run:

RESTORE DATBASE [DatabaseName] FROM DISK='path to full backup' WITH NO RECOVERY, <Any move options required>

You then need to restore any differential backups...

Hi Jonathan,

What sort of manipulations are you doing? Can you post the DDL for your Views and we might be able to get them working without a significant performance hit.

James

Jurgen,

A Snapshot backup would be the fastest way to backup your data however this can often be very expensive as it require three way mirror drives.

Replication, or log shipping, would...

No problem, always happy to help,

James

Does DATENAME do what you want? http://msdn2.microsoft.com/en-us/library/ms174395.aspx

James

John,

If the three databases are all on one server then there should be no serious overhead of doing a cross database query.

How much data are you trying to report on?...

Hi,

If you are using SQL Server 2005 you can do this very nicely with CTE's (Common Table Expressions) - have a look at http://www.sqlservercentral.com/columnists/sSampath/recursivequeriesinsqlserver2005.asp - if you are using SQL 2000...

Bah.. beaten by Jeff.. that man is unstoppable

Somthing like...

DECLARE @firstDayOfMonth DATETIME

DECLARE @lastDayOfMonth DATETIME

DECLARE @firstDayOfNextMonth DATETIME

SELECT @firstDayOfMonth = DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0)

SELECT @firstDayOfNextMonth = DATEADD(mm, 1, @firstDayOfMonth)

SELECT @lastDayOfMonth = DATEADD(dd, -1, @firstDayOfNextMonth)

SELECT @firstDayOfMonth [FirstDayOfMonth], @lastDayOfMonth [LastDayOfMonth], @firstDayOfNextMonth [FirstDayOfNextMonth]

James

Taylor,

What expression do you have to do this? I would imagine it is somthing along the lines of

sp_addlinkedserver

@server='AccessDb',

@srvproduct='Acess',

@provider='Microsoft.Jet.OLEDB.4.0',

@datasrc='C:\nwind.mdb'

If so you just put this in a query...

Jason,

There is some documentation on it around which seems to suggest its OK. The only time I have done it I ended up playing with fixing linked servers/remote logins, jobs,...

Have a look here - http://msdn2.microsoft.com/en-us/library/ms190737.aspx you should be able to get it started using some combination of the mentioned flags - probably -m or -f and then drop the...

Just gave this a go myself you can do this is Viso fairly well - will probably require a little tweaking - Go file -> new diagram -> database ->...

Hi Colin,

What behaviour are you seeing and what are you expecting to happen - it sounds from your question as though you are having partial success in this?

- James