Johan,

I hope you had an enjoyable vacation.

When I do not know what I am doing, I look for examples and try to follow them. My reasoning was that since SQL...

Ed, Thank you for your comments.

Johan, I completed the restore just now. Thank you for your help.

Below is a summary of the steps I took for future reference.

1. Used to...

Johan,

I appreciate your patience.

I used

RESTORE FILELISTONLY FROM DISK = 'E:\Backup\Data_02 Aug 8 2022.bak'

To get the physical file names.

In a separate query window I used

select...

• This reply was modified 2 years, 3 months ago by  mpdillon.

Johan,

I was afraid you were going to say that. I did explore that option as suggested by your first post. But I cannot make heads or tails out of it....

Should the code below work? Is this the correct method for renaming the ndf?

USE [master]
Declare @newNDF as varchar(100) = 'E:\DATA\ftrow_FTC_titles{' + cast(NewID() as varchar(100)) +'}.ndf'
RESTORE DATABASE [Data]
FROM...

In Sql 2008 R2 I could not find Security Policies. I did find Securables. I checked the GRANT check box for Create Any Database. I had to log in as...

Johan, Ed and Jeff, Thank you all for your assistance. I have a much better understanding of the process now. Over the weekend more space was added to this server....

Johan,

Thank you for the quick reply.

I tried the code "alter database [yourdb] set recovery simple with nowait;". However, SSMS generated an error on "with nowait". When I removed the clause...

Andy,

Thank you for your reply. Sorry about the zip. I was looking for a way to attach a doc of some sort. I ruled out Word. Thought PDF would be...

Third try

First upload failed. Trying a Zip file of the pdf

Thank you for confirming what I suspected.
Pat

Update. It does not seem to be a permissions issue. I believe it is a syntax issue.

Truncate Table [FS-JirEMSQL].JIREM10.dbo.JIRABConcentration Fails

But

Truncate Table JIREM10.dbo.JIRABConcentration is successful.

It...

SS,

Thank you for your efforts. So that other who read this will have a better understanding without having to recreate the tables and queries, I have added a Identity field...

First let me offer an apology to everyone who has tried to use the data I supplied. it was bad, even the second set. Sorry.

Insert into OverlapTest

(ItemNo, Start_Dt, End_Dt)

Select 'A',20150101,20151231

Union...