As Brian states, as long as you don't have to recover any custom stored procedures that you built into master you're probably ok if you have a script of your...

By the sounds of it you are going into SQL Server via Enterprise Manager (correct me if I'm wrong).

Have you tried starting SQL Server from the command prompt, using "sqlservr.exe...

You need to be a memeber of the TargetServersRole role in the msdb database. I have a feeling that this role grants more than just execute permissions though. ...

I'm not sure I understand your question.

Your statement above is valid except for a small syntax error. You need to define the parameter's datatype.

declare @var int

select @var = count(*)...

You can use SQL Server jobs to do this quite easly.

Create a job step that executes as a cmdexec, which will allow you to run the dos command to unzip...

Hi,

there are various ways in which you could do this and I'm sure you'll get some other posts with other solutions but here's a one of ways that come to...

Sven,

is there any reason why you don't want to use SQL Server backups?

I would recommend using SQL Server native backups or something that directly interfaces with SQL Server....

Hi Helen,

Check the error log to see if there's a more detailed answer.

Couple of things that first spring to mind and are worth checking. Check the database is not...

Yep, placing the data files and OS on the same array and then place the logs on their own array.  It really isn't ideal but it's the best option in...

RAID 10 only needs a minimum of 4 disks, not 10. RAID 10 is a mirrored set of a stripe, or a striped set of a mirror.

The biggest single...

Ed,

about the filelist error you got. Haven't seen that one before to be honest.

Run the following:

restore verifyonly from disk = ''

In theory it should return "Backup set is valid".

Hi,

you can do this by using the CONVERT function and the style option to specify that you only want the time:

select

@date1

Karl
source control for SQL Server