Hi Lowell,

Thanks for your answer. Unfortunately I didn't write my question all too well...

We have done all what you wrote. De SSP's on Report run flawlessly.

However, sometimes the SP's get...

Thanks for all your answers. Here are some answers to raised questions:

* Currently we have no real bottlenecks. Sometimes we see that the CPU is going up t0 80% and...

Hi Paul,

You are completely right.... I rewrote my code per your advise and it works like a charm.... thanks a lot!

Raymond

Thanks for your replies.

I actually need it for the following: because I must run the query on a table I don't know the name of beforehand, I must use a...

Two examples of database files:

26GB mdf + 12GB ldf

10GB mdf + 28GB ldf

When I look at previous backups, the BAK files have grown 2GB overnight.

type of backup is: FULL

Hi,

Just got word from our datacenter provider. It's a VMWare backup.

Thx,

Raymond

Think I got it.... wrong syntax! I have to use: STANDBY = N'E:\SQLData\mydb_undofile.bak'

Good articles on this subject:

http://sqlserverpedia.com/wiki/Restore_With_Standby

http://www.devx.com/getHelpOn/10MinuteSolution/16503/1763/page/3

Thanks to all

Indeed, I need a report server.

John, I made a typo error, sorry for that. I meant to say: I do *not* get an error.

What I do not understand at...

Type error: I do *not* get an error when restoring WITH STANDBY

Hi,

I tried the following:

CREATE DATABASE [mydb] ON ( NAME = [mydb], FILENAME = ''E:\SQLData\mydb.mdf'' )

RESTORE DATABASE [mydb] FROM DISK = N'\\vs667\Backup Servers\SQLBACKUP\mydb\mydb_backup_2011_10_07_000104_2109063.f.bak' WITH NORECOVERY, FILE = 1, REPLACE

Booh: It restores...

The only thing I can think of is making the synonym name different per user (so if your employeenumber is "23", your synonym will be "T23").... meaning that I am...

Boooh!!

One thing I see now is that the synonym is database-wide. Meaning, if I am running a query using synonym T, my colleague can't do a thing (except exactly the...

In the last 24 hours it didn't happen again, thank God. My hosting company is still investigating. Microsoft has received the dumpfiles and is also looking into it.....

Thx for y'r replies. They charged SQL Standard (330 euro excl VAT), while the version showed Workgroup (78 euro excl VAT).....!!!

Thanks for your replies! I have set up Log Shipping succcessfully and it works okay.

However, one issue!

I would like to use the secondary server for reporting. When I set up...