Difference between Backup/Restore & Attach/Detach

Can someone please clarify the difference between Detach / Attach of MDF/LDF
files versus the Backup / Restore of backup to device/file feature? Which
would be ideal for restores of actual databases?
Thank you.Transact-SQL BACKUP/RESTORE is the normal method for database backup and
recovery. Databases can be backed up while online. The backup file size is
usually smaller than the database files since only used pages are backed up.
Also, in the FULL or BULK_LOGGED recovery model, you can reduce potential
data loss by performing transaction log backups.
Detaching a database removes the database from SQL Server while leaving the
physical database files intact. This allows you to rename or move the
physical files and then re-attach. Although one could perform cold backups
using this technique, detach/attach isn't really intended to be used as a
backup/recovery process.
Hope this helps.
Dan Guzman
SQL Server MVP
"KP" <kp@.msn.com> wrote in message
news:%23PtI97whFHA.3300@.TK2MSFTNGP15.phx.gbl...
> Can someone please clarify the difference between Detach / Attach of
> MDF/LDF files versus the Backup / Restore of backup to device/file
> feature? Which would be ideal for restores of actual databases?
> Thank you.
>|||Thanks for the explanation. If I was to restore a WSS or SPS which uses SQL
that exists in one domain and restore to another domain - would the Backup /
Restore be better?
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:u85i3JxhFHA.3316@.TK2MSFTNGP14.phx.gbl...
> Transact-SQL BACKUP/RESTORE is the normal method for database backup and
> recovery. Databases can be backed up while online. The backup file size
> is usually smaller than the database files since only used pages are
> backed up. Also, in the FULL or BULK_LOGGED recovery model, you can reduce
> potential data loss by performing transaction log backups.
> Detaching a database removes the database from SQL Server while leaving
> the physical database files intact. This allows you to rename or move the
> physical files and then re-attach. Although one could perform cold
> backups using this technique, detach/attach isn't really intended to be
> used as a backup/recovery process.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "KP" <kp@.msn.com> wrote in message
> news:%23PtI97whFHA.3300@.TK2MSFTNGP15.phx.gbl...
>|||I usually use backup/restore to move databases between servers. It doesn't
matter if the servers on a different domains.
After you restore to another box, you'll need to make sure you don't have
orphaned users. See sp_change_users_login in the Books Online for
information on how to report/correct the users.
Hope this helps.
Dan Guzman
SQL Server MVP
"KP" <kp@.msn.com> wrote in message
news:eiTM5UxhFHA.3300@.TK2MSFTNGP15.phx.gbl...
> Thanks for the explanation. If I was to restore a WSS or SPS which uses
> SQL that exists in one domain and restore to another domain - would the
> Backup / Restore be better?
>
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:u85i3JxhFHA.3316@.TK2MSFTNGP14.phx.gbl...
>

Difference between Backup/Restore & Attach/Detach

Can someone please clarify the difference between Detach / Attach of MDF/LDF
files versus the Backup / Restore of backup to device/file feature? Which
would be ideal for restores of actual databases?
Thank you.Transact-SQL BACKUP/RESTORE is the normal method for database backup and
recovery. Databases can be backed up while online. The backup file size is
usually smaller than the database files since only used pages are backed up.
Also, in the FULL or BULK_LOGGED recovery model, you can reduce potential
data loss by performing transaction log backups.
Detaching a database removes the database from SQL Server while leaving the
physical database files intact. This allows you to rename or move the
physical files and then re-attach. Although one could perform cold backups
using this technique, detach/attach isn't really intended to be used as a
backup/recovery process.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"KP" <kp@.msn.com> wrote in message
news:%23PtI97whFHA.3300@.TK2MSFTNGP15.phx.gbl...
> Can someone please clarify the difference between Detach / Attach of
> MDF/LDF files versus the Backup / Restore of backup to device/file
> feature? Which would be ideal for restores of actual databases?
> Thank you.
>|||Thanks for the explanation. If I was to restore a WSS or SPS which uses SQL
that exists in one domain and restore to another domain - would the Backup /
Restore be better?
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:u85i3JxhFHA.3316@.TK2MSFTNGP14.phx.gbl...
> Transact-SQL BACKUP/RESTORE is the normal method for database backup and
> recovery. Databases can be backed up while online. The backup file size
> is usually smaller than the database files since only used pages are
> backed up. Also, in the FULL or BULK_LOGGED recovery model, you can reduce
> potential data loss by performing transaction log backups.
> Detaching a database removes the database from SQL Server while leaving
> the physical database files intact. This allows you to rename or move the
> physical files and then re-attach. Although one could perform cold
> backups using this technique, detach/attach isn't really intended to be
> used as a backup/recovery process.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "KP" <kp@.msn.com> wrote in message
> news:%23PtI97whFHA.3300@.TK2MSFTNGP15.phx.gbl...
>> Can someone please clarify the difference between Detach / Attach of
>> MDF/LDF files versus the Backup / Restore of backup to device/file
>> feature? Which would be ideal for restores of actual databases?
>> Thank you.
>|||I usually use backup/restore to move databases between servers. It doesn't
matter if the servers on a different domains.
After you restore to another box, you'll need to make sure you don't have
orphaned users. See sp_change_users_login in the Books Online for
information on how to report/correct the users.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"KP" <kp@.msn.com> wrote in message
news:eiTM5UxhFHA.3300@.TK2MSFTNGP15.phx.gbl...
> Thanks for the explanation. If I was to restore a WSS or SPS which uses
> SQL that exists in one domain and restore to another domain - would the
> Backup / Restore be better?
>
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:u85i3JxhFHA.3316@.TK2MSFTNGP14.phx.gbl...
>> Transact-SQL BACKUP/RESTORE is the normal method for database backup and
>> recovery. Databases can be backed up while online. The backup file size
>> is usually smaller than the database files since only used pages are
>> backed up. Also, in the FULL or BULK_LOGGED recovery model, you can
>> reduce potential data loss by performing transaction log backups.
>> Detaching a database removes the database from SQL Server while leaving
>> the physical database files intact. This allows you to rename or move
>> the physical files and then re-attach. Although one could perform cold
>> backups using this technique, detach/attach isn't really intended to be
>> used as a backup/recovery process.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "KP" <kp@.msn.com> wrote in message
>> news:%23PtI97whFHA.3300@.TK2MSFTNGP15.phx.gbl...
>> Can someone please clarify the difference between Detach / Attach of
>> MDF/LDF files versus the Backup / Restore of backup to device/file
>> feature? Which would be ideal for restores of actual databases?
>> Thank you.
>>
>

Difference between Backup/Restore & Attach/Detach

Can someone please clarify the difference between Detach / Attach of MDF/LDF
files versus the Backup / Restore of backup to device/file feature? Which
would be ideal for restores of actual databases?
Thank you.
Transact-SQL BACKUP/RESTORE is the normal method for database backup and
recovery. Databases can be backed up while online. The backup file size is
usually smaller than the database files since only used pages are backed up.
Also, in the FULL or BULK_LOGGED recovery model, you can reduce potential
data loss by performing transaction log backups.
Detaching a database removes the database from SQL Server while leaving the
physical database files intact. This allows you to rename or move the
physical files and then re-attach. Although one could perform cold backups
using this technique, detach/attach isn't really intended to be used as a
backup/recovery process.
Hope this helps.
Dan Guzman
SQL Server MVP
"KP" <kp@.msn.com> wrote in message
news:%23PtI97whFHA.3300@.TK2MSFTNGP15.phx.gbl...
> Can someone please clarify the difference between Detach / Attach of
> MDF/LDF files versus the Backup / Restore of backup to device/file
> feature? Which would be ideal for restores of actual databases?
> Thank you.
>
|||Thanks for the explanation. If I was to restore a WSS or SPS which uses SQL
that exists in one domain and restore to another domain - would the Backup /
Restore be better?
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:u85i3JxhFHA.3316@.TK2MSFTNGP14.phx.gbl...
> Transact-SQL BACKUP/RESTORE is the normal method for database backup and
> recovery. Databases can be backed up while online. The backup file size
> is usually smaller than the database files since only used pages are
> backed up. Also, in the FULL or BULK_LOGGED recovery model, you can reduce
> potential data loss by performing transaction log backups.
> Detaching a database removes the database from SQL Server while leaving
> the physical database files intact. This allows you to rename or move the
> physical files and then re-attach. Although one could perform cold
> backups using this technique, detach/attach isn't really intended to be
> used as a backup/recovery process.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "KP" <kp@.msn.com> wrote in message
> news:%23PtI97whFHA.3300@.TK2MSFTNGP15.phx.gbl...
>
|||I usually use backup/restore to move databases between servers. It doesn't
matter if the servers on a different domains.
After you restore to another box, you'll need to make sure you don't have
orphaned users. See sp_change_users_login in the Books Online for
information on how to report/correct the users.
Hope this helps.
Dan Guzman
SQL Server MVP
"KP" <kp@.msn.com> wrote in message
news:eiTM5UxhFHA.3300@.TK2MSFTNGP15.phx.gbl...
> Thanks for the explanation. If I was to restore a WSS or SPS which uses
> SQL that exists in one domain and restore to another domain - would the
> Backup / Restore be better?
>
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:u85i3JxhFHA.3316@.TK2MSFTNGP14.phx.gbl...
>
sql

Difference between backing up to a file and a logical backup device?

What's is the between backing up a database to a file and a logical backup device?

If I point the logical backup device to a file on the filesystem, it's same as backing up to a file? isn't?

Thanks

Yep, that is right, the backup device just allows you to change the underlying target for the backup without changing the backup jobs themselves.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

device is ambiguous in the namespace microsoft.directx.direc3d

Can anybody tell me what this error message means. I get it when trying to use directx3d. The code is included below.

I have checked and double checked that I have all the necessary references and includes. Obviously I am missing something.
Thanks Dick

Imports System

Imports System.Drawing

Imports System.Windows.Forms

Imports Microsoft.DirectX

Imports Microsoft.DirectX.Direct3D

Public Class Form1

Inherits System.Windows.Forms.Form

Dim device As Device ' Our rendering device

#Region "Windows Form Designer generated code "

Public Sub New()

MyBase.New()

'This call is required by the Windows Form Designer.

InitializeComponent()

End Sub

'Form overrides dispose to clean up the component list.

Protected Overloads Overrides Sub Dispose(ByVal Disposing As Boolean)

If Disposing Then

If Not components Is Nothing Then

components.Dispose()

End If

End If

MyBase.Dispose(Disposing)

End Sub

'Required by the Windows Form Designer

#End Region

Public Function InitializeGraphics() As Boolean

Try

' Now let's setup our D3D stuff

Dim presentParams As PresentParameters = New PresentParameters()

presentParams.Windowed = True

presentParams.SwapEffect = SwapEffect.Discard

device = New Device(0, DeviceType.Hardware, this, CreateFlags.SoftwareVertexProcessing, presentParams)

Return True

Catch

Return False

End Try

End Function

Private Sub Render()

If device Is Nothing Then

Exit Sub

End If

'Clear the backbuffer to a blue color

device.Clear(ClearFlags.Target, System.Drawing.Color.Blue, 1.0F, 0)

'Begin the scene

device.BeginScene()

' Rendering of scene objects can happen here

'End the scene

device.EndScene()

device.Present()

End Sub

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

If Not InitializeGraphics() Then

MessageBox.Show("Could not initialize Direct3D. This tutorial will exit.")

Exit Sub

End If

Me.Show()

' While the form is still valid, render and process messages

Do While Me.Created

Render()

Application.DoEvents()

Loop

End Sub

End Class

This is a SQL Server forum. I think you've accidentally posted to the wrong place...

device is ambiguous in the namespace microsoft.directx.direc3d

Can anybody tell me what this error message means. I get it when trying to use directx3d. The code is included below.

I have checked and double checked that I have all the necessary references and includes. Obviously I am missing something.
Thanks Dick

Imports System

Imports System.Drawing

Imports System.Windows.Forms

Imports Microsoft.DirectX

Imports Microsoft.DirectX.Direct3D

Public Class Form1

Inherits System.Windows.Forms.Form

Dim device As Device ' Our rendering device

#Region "Windows Form Designer generated code "

Public Sub New()

MyBase.New()

'This call is required by the Windows Form Designer.

InitializeComponent()

End Sub

'Form overrides dispose to clean up the component list.

Protected Overloads Overrides Sub Dispose(ByVal Disposing As Boolean)

If Disposing Then

If Not components Is Nothing Then

components.Dispose()

End If

End If

MyBase.Dispose(Disposing)

End Sub

'Required by the Windows Form Designer

#End Region

Public Function InitializeGraphics() As Boolean

Try

' Now let's setup our D3D stuff

Dim presentParams As PresentParameters = New PresentParameters()

presentParams.Windowed = True

presentParams.SwapEffect = SwapEffect.Discard

device = New Device(0, DeviceType.Hardware, this, CreateFlags.SoftwareVertexProcessing, presentParams)

Return True

Catch

Return False

End Try

End Function

Private Sub Render()

If device Is Nothing Then

Exit Sub

End If

'Clear the backbuffer to a blue color

device.Clear(ClearFlags.Target, System.Drawing.Color.Blue, 1.0F, 0)

'Begin the scene

device.BeginScene()

' Rendering of scene objects can happen here

'End the scene

device.EndScene()

device.Present()

End Sub

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

If Not InitializeGraphics() Then

MessageBox.Show("Could not initialize Direct3D. This tutorial will exit.")

Exit Sub

End If

Me.Show()

' While the form is still valid, render and process messages

Do While Me.Created

Render()

Application.DoEvents()

Loop

End Sub

End Class

This is a SQL Server forum. I think you've accidentally posted to the wrong place...

Device Information Settings for HTMLOWC

I posted this question a few days ago and never got a response. Does anyone
know the answer to this?
I see all the device information settings for all the other output formats.
Is there a way to pass device information to the pivot tables? If not, is
this planned for future releases?
I have 5 other posts related to matrix's and pivot tables that never got a
response for one reason or another. They were all posted on 8/11 and 8/12.To my knowledge there are not any device information settings specific to
pivot tables. I am not aware of any future plans to support that.
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"clortex" <clortex@.discussions.microsoft.com> wrote in message
news:A96DFECB-CC15-43EA-A181-291E0707317A@.microsoft.com...
> I posted this question a few days ago and never got a response. Does
anyone
> know the answer to this?
> I see all the device information settings for all the other output
formats.
> Is there a way to pass device information to the pivot tables? If not, is
> this planned for future releases?
> I have 5 other posts related to matrix's and pivot tables that never got a
> response for one reason or another. They were all posted on 8/11 and 8/12.

Device Information Settings - SimplePageHeader

I am trying to use the new SimplePageHeader device information setting
which was introduced in RS SP1 for Excel exporting but have not seen
any impact when using the setting. Following is an example of how I
am using the setting in an URL:
...ReportName&rs:Command=Render&rs:Format=EXCEL&rc:SimplePageHeader=True
My motivation for using this setting was an attempt to stop the export
from merging several of the columns in the report since this results
in the error "This operation requires the merged cells to be
identically sized" when trying to sort on various columns within
Excel. My thought was that by moving the header out of the actual
worksheet (which is my understanding from the documentation of what
the setting is supposed to do), the rendered report may not need to
merge cells to get the output formatted properly. Any suggestions
would be appreciated.I think the device info is SimplePageHeaders.
--
Nico Cristache [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"f_mumble" <fred_mumble@.yahoo.com> wrote in message
news:5e9391dd.0406281737.724e4c66@.posting.google.com...
> I am trying to use the new SimplePageHeader device information setting
> which was introduced in RS SP1 for Excel exporting but have not seen
> any impact when using the setting. Following is an example of how I
> am using the setting in an URL:
> ...ReportName&rs:Command=Render&rs:Format=EXCEL&rc:SimplePageHeader=True
> My motivation for using this setting was an attempt to stop the export
> from merging several of the columns in the report since this results
> in the error "This operation requires the merged cells to be
> identically sized" when trying to sort on various columns within
> Excel. My thought was that by moving the header out of the actual
> worksheet (which is my understanding from the documentation of what
> the setting is supposed to do), the rendered report may not need to
> merge cells to get the output formatted properly. Any suggestions
> would be appreciated.|||Thanks for the follow-up, but adding the 's' didn't make a difference.
Are my expectations of what this device info setting supposed to
accomplish accurate?
As a test I completely removed the header from the report, and as I
suspected the columns are no longer merged in Excel. As a result,
Excel is able to sort any of the columns with no problems.
Unfortunately, having no header on the report is not an option, so any
other suggestions are welcome.
"Nico Cristache [MSFT]" <nipirvan@.microsoft.com> wrote in message news:<uFBPjyXXEHA.796@.TK2MSFTNGP10.phx.gbl>...
> I think the device info is SimplePageHeaders.
> --
> Nico Cristache [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "f_mumble" <fred_mumble@.yahoo.com> wrote in message
> news:5e9391dd.0406281737.724e4c66@.posting.google.com...
> > I am trying to use the new SimplePageHeader device information setting
> > which was introduced in RS SP1 for Excel exporting but have not seen
> > any impact when using the setting. Following is an example of how I
> > am using the setting in an URL:
> >
> > ...ReportName&rs:Command=Render&rs:Format=EXCEL&rc:SimplePageHeader=True
> >
> > My motivation for using this setting was an attempt to stop the export
> > from merging several of the columns in the report since this results
> > in the error "This operation requires the merged cells to be
> > identically sized" when trying to sort on various columns within
> > Excel. My thought was that by moving the header out of the actual
> > worksheet (which is my understanding from the documentation of what
> > the setting is supposed to do), the rendered report may not need to
> > merge cells to get the output formatted properly. Any suggestions
> > would be appreciated.|||I eventually found out how to use the device info. Here are my findings:
It IS SimplePageHeaders - with an 's', plural
I used it as part of the URL when rendering directly to Excel. (I couldn't
find any way of settign this device information at design time?) The URL was
of this form
http://myserver/ReportServer?%2fTDSI%2fAssetsSummary&FxRate=1.2&rs:Command=Render&rs:Format=EXCEL&rc:SimplePageHeaders=True
This outputted my report into Excel but I think SimplePageHeaders means no
header. My original report had images and text boxes in the header (which
were admittedly causing the cell merges) but following the above the
spreadsheet does not show any of these. Is this the best I can get?
"f_mumble" wrote:
> Thanks for the follow-up, but adding the 's' didn't make a difference.
> Are my expectations of what this device info setting supposed to
> accomplish accurate?
> As a test I completely removed the header from the report, and as I
> suspected the columns are no longer merged in Excel. As a result,
> Excel is able to sort any of the columns with no problems.
> Unfortunately, having no header on the report is not an option, so any
> other suggestions are welcome.
>
> "Nico Cristache [MSFT]" <nipirvan@.microsoft.com> wrote in message news:<uFBPjyXXEHA.796@.TK2MSFTNGP10.phx.gbl>...
> > I think the device info is SimplePageHeaders.
> >
> > --
> > Nico Cristache [MSFT]
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "f_mumble" <fred_mumble@.yahoo.com> wrote in message
> > news:5e9391dd.0406281737.724e4c66@.posting.google.com...
> > > I am trying to use the new SimplePageHeader device information setting
> > > which was introduced in RS SP1 for Excel exporting but have not seen
> > > any impact when using the setting. Following is an example of how I
> > > am using the setting in an URL:
> > >
> > > ...ReportName&rs:Command=Render&rs:Format=EXCEL&rc:SimplePageHeader=True
> > >
> > > My motivation for using this setting was an attempt to stop the export
> > > from merging several of the columns in the report since this results
> > > in the error "This operation requires the merged cells to be
> > > identically sized" when trying to sort on various columns within
> > > Excel. My thought was that by moving the header out of the actual
> > > worksheet (which is my understanding from the documentation of what
> > > the setting is supposed to do), the rendered report may not need to
> > > merge cells to get the output formatted properly. Any suggestions
> > > would be appreciated.
>

Device holding MASTER, MODEL, MSDB, and TempDB FULL

I have other drives that are quite large that I could move any one of these
to. Not sure how to do the move...this is a production server and down
time needs to be almost non-existent.
TempDB is taking up 1 gig, if there was a way to move it without bringing
down the server, that would be great (like adding a file to new drive, then
shrinking with EMPTY_FILE on old drive.....can this be done during
production or would it cause slowness or locking, etc.?)What version of SQL Server are you using ...?
Have you tried Shrinking it. DBCC SHRINKFILE
HTH
Ryan Waight, MCDBA, MCSE
"John Hamilton" <jhamil@.nowhere.com> wrote in message
news:ODt9rtJnDHA.2528@.TK2MSFTNGP12.phx.gbl...
> I have other drives that are quite large that I could move any one of
these
> to. Not sure how to do the move...this is a production server and down
> time needs to be almost non-existent.
> TempDB is taking up 1 gig, if there was a way to move it without bringing
> down the server, that would be great (like adding a file to new drive,
then
> shrinking with EMPTY_FILE on old drive.....can this be done during
> production or would it cause slowness or locking, etc.?)
>|||I'm using 2000, and I tried DBCC SHRINKFILE, it didn't change the size.
"Ryan Waight" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:eWnaIzJnDHA.2012@.TK2MSFTNGP12.phx.gbl...
> What version of SQL Server are you using ...?
> Have you tried Shrinking it. DBCC SHRINKFILE
>
> --
> HTH
> Ryan Waight, MCDBA, MCSE
> "John Hamilton" <jhamil@.nowhere.com> wrote in message
> news:ODt9rtJnDHA.2528@.TK2MSFTNGP12.phx.gbl...
> > I have other drives that are quite large that I could move any one of
> these
> > to. Not sure how to do the move...this is a production server and down
> > time needs to be almost non-existent.
> >
> > TempDB is taking up 1 gig, if there was a way to move it without
bringing
> > down the server, that would be great (like adding a file to new drive,
> then
> > shrinking with EMPTY_FILE on old drive.....can this be done during
> > production or would it cause slowness or locking, etc.?)
> >
> >
>|||Tried SHRINKFILE again and it worked this time....'?
"Ryan Waight" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:eWnaIzJnDHA.2012@.TK2MSFTNGP12.phx.gbl...
> What version of SQL Server are you using ...?
> Have you tried Shrinking it. DBCC SHRINKFILE
>
> --
> HTH
> Ryan Waight, MCDBA, MCSE
> "John Hamilton" <jhamil@.nowhere.com> wrote in message
> news:ODt9rtJnDHA.2528@.TK2MSFTNGP12.phx.gbl...
> > I have other drives that are quite large that I could move any one of
> these
> > to. Not sure how to do the move...this is a production server and down
> > time needs to be almost non-existent.
> >
> > TempDB is taking up 1 gig, if there was a way to move it without
bringing
> > down the server, that would be great (like adding a file to new drive,
> then
> > shrinking with EMPTY_FILE on old drive.....can this be done during
> > production or would it cause slowness or locking, etc.?)
> >
> >
>|||Have a look at this :- http://www.aspfaq.com/show.asp?id=2446
good for future reference..
--
HTH
Ryan Waight, MCDBA, MCSE
"John Hamilton" <jhamil@.nowhere.com> wrote in message
news:%234Iku4JnDHA.2080@.TK2MSFTNGP10.phx.gbl...
> Tried SHRINKFILE again and it worked this time....'?
>
> "Ryan Waight" <Ryan_Waight@.nospam.hotmail.com> wrote in message
> news:eWnaIzJnDHA.2012@.TK2MSFTNGP12.phx.gbl...
> > What version of SQL Server are you using ...?
> >
> > Have you tried Shrinking it. DBCC SHRINKFILE
> >
> >
> >
> > --
> > HTH
> > Ryan Waight, MCDBA, MCSE
> >
> > "John Hamilton" <jhamil@.nowhere.com> wrote in message
> > news:ODt9rtJnDHA.2528@.TK2MSFTNGP12.phx.gbl...
> > > I have other drives that are quite large that I could move any one of
> > these
> > > to. Not sure how to do the move...this is a production server and
down
> > > time needs to be almost non-existent.
> > >
> > > TempDB is taking up 1 gig, if there was a way to move it without
> bringing
> > > down the server, that would be great (like adding a file to new drive,
> > then
> > > shrinking with EMPTY_FILE on old drive.....can this be done during
> > > production or would it cause slowness or locking, etc.?)
> > >
> > >
> >
> >
>|||This would indicate an open transaction was preventing the shrink. DBCC
OPENTRAN shows any open transcations
--
HTH
Ryan Waight, MCDBA, MCSE
"John Hamilton" <jhamil@.nowhere.com> wrote in message
news:%234Iku4JnDHA.2080@.TK2MSFTNGP10.phx.gbl...
> Tried SHRINKFILE again and it worked this time....'?
>
> "Ryan Waight" <Ryan_Waight@.nospam.hotmail.com> wrote in message
> news:eWnaIzJnDHA.2012@.TK2MSFTNGP12.phx.gbl...
> > What version of SQL Server are you using ...?
> >
> > Have you tried Shrinking it. DBCC SHRINKFILE
> >
> >
> >
> > --
> > HTH
> > Ryan Waight, MCDBA, MCSE
> >
> > "John Hamilton" <jhamil@.nowhere.com> wrote in message
> > news:ODt9rtJnDHA.2528@.TK2MSFTNGP12.phx.gbl...
> > > I have other drives that are quite large that I could move any one of
> > these
> > > to. Not sure how to do the move...this is a production server and
down
> > > time needs to be almost non-existent.
> > >
> > > TempDB is taking up 1 gig, if there was a way to move it without
> bringing
> > > down the server, that would be great (like adding a file to new drive,
> > then
> > > shrinking with EMPTY_FILE on old drive.....can this be done during
> > > production or would it cause slowness or locking, etc.?)
> > >
> > >
> >
> >
>

Device error or device off-line. ?

Hi to All

when i m trying to execute following code

backup database web
to disk = 'c:\inetpub\wwwroot\backup\mybakup.bak'
with format

I m Getting Error like :

Server: Msg 3201, Level 16, State 1, Line 1
Cannot open backup device 'c:\inetpub\wwwroot\backup\mybakup.bak'. Device error or device off-line. See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

This error is Generated only when i m trying to access folders within "wwwroot" but not in any other folders , even command runs success fully for "wwwroot" folder . !!

but not for any subfolders of wwwroot.

Can Any One Help Me ?

Please follow the post in the other group, you don′t have to mulitpost as we the groups are all monitored.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Device error or device off-line ?

Hi to All

when i m trying to execute following code

backup database web
to disk = 'c:\inetpub\wwwroot\backup\mybakup.bak'
with format

I m Getting Error like :

Server: Msg 3201, Level 16, State 1, Line 1
Cannot open backup device 'c:\inetpub\wwwroot\backup\mybakup.bak'. Device error or device off-line. See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

This error is Generated only when i m trying to access folders within "wwwroot" but not in any other folders , even command runs success fully for "wwwroot" folder . !!

but not for any subfolders of wwwroot.

Can Any One Help Me ?

What does show

xp_cmdshell "dir c:\inetpub\wwwroot\backup"

?

|||

DO the subfolders inherit the permission from the wwwroot folder ? Make sure that this isn′t a permission problem. What does (like the message says the error log tell you about the problem?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

i m using Sql Server 2000 (sp3);

command

xp_cmdshell "dir c:\inetpub\wwwroot\backup"

gives following error:

Server: Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'xp_cmdshell'.

|||

All Permission have been set properly.

but error is still as it is.

|||

the xp_cmdshell is located in the master database, so you have to prefix the database name or need to have your curretn context in the master database.

master.xp_cmdshell "dir c:\inetpub\wwwroot\backup"

or

Use master
GO
xp_cmdshell "dir c:\inetpub\wwwroot\backup"

HTH, JEns Suessmeyer.

http://www.sqlserver2005.de

|||

Hi,

sometime people think that the path within any TSQL commands can be also used locally, so if you are working in a client server scenario and you issue the command BACKUP DATABASE with some path and filename (with absolute drive letters), the drive letters apply to the server not the client. If you want to reach a destination on the client machine, you have to copy it via a UNC share.

Don′t know if that applies to you, just to let you know. If this is not the case, please see if the listing of the directory comes back with a listing of files (then it really HAS to be a permission problem) or it comes back with an error that the directory doesn′t exists.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

device CALs

Hi,

I am slightly confused about the meaning of a 'device cal'
(specifically for sql server but I guess the same applies to other ms
licences)

In the examples about device cals, there is a picture of a number of
windows desktops connected to a database server. each desktop can
potentially be used by a number of users and requires one device cal.
All well and good.

Now, say I have a web application hosted hosted on a different machine
and connecting to SQL server. the SQL server licencing FAQ says

"A device CAL covers multiple users' access to server software from a
single, shared device."

is my web server a shared device? so does the web server require a
single device CAL no matter how many users use it?

AndyFor a database that is accessible via a Web application you must use a
Processor Licence. Device CALs then aren't required.

--
David Portas
SQL Server MVP
--|||"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:RM6dnYcDYblGvpzcRVn-jA@.giganews.com...
> For a database that is accessible via a Web application you must use a
> Processor Licence. Device CALs then aren't required.

I'm going to jump in here and say, "I'm not sure that's quite 100% true."
If it's publically accessed or access is not controlled in some assured
method (i.e. login, etc.) I believe it's true. Last time I checked, I think
if you had say an in-house application (say an accounting package) and each
desktop had a CAL covering it, you'd be covered.

Has this changed?

> --
> David Portas
> SQL Server MVP
> --|||Hi David

Regarding your answer, do they really expect someone to buy a processor
license for 3,185.00 / US$ 5800 ?? That's not feasable for small sites..

The MSDE 2000A EULA says:
4. NO RENTAL/COMMERCIAL HOSTING. You may not rent, lease, lend or provide
commercial hosting services with the Software.

Does that mean I cannot have a web application using MSDE as a backend
database?
If not, MSDE would be a good solution, given someone can live with the
limitations.

Also, do you know, that's more of a Windos Server 2003 Web Edition question
but goes in the same direction:
Microsoft says it's prohibited to install any applications on the Web
Edition. Does this include MSDE 2000A?

Thanks for your thoughts!

Martin

"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:RM6dnYcDYblGvpzcRVn-jA@.giganews.com...
> For a database that is accessible via a Web application you must use a
> Processor Licence. Device CALs then aren't required.
> --
> David Portas
> SQL Server MVP
> --|||"Greg D. Moore \(Strider\)" <mooregr_deleteth1s@.greenms.com> wrote in message news:<FHjMc.57026$yd5.37453@.twister.nyroc.rr.com>...
> "David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
> news:RM6dnYcDYblGvpzcRVn-jA@.giganews.com...
> > For a database that is accessible via a Web application you must use a
> > Processor Licence. Device CALs then aren't required.
> I'm going to jump in here and say, "I'm not sure that's quite 100% true."
> If it's publically accessed or access is not controlled in some assured
> method (i.e. login, etc.) I believe it's true. Last time I checked, I think
> if you had say an in-house application (say an accounting package) and each
> desktop had a CAL covering it, you'd be covered.

what I'm not sure is what is the definition of a device? why should
each desktop require a CAL when the only "device" (i.e. computer?)
accessing SQL is the web server machine?

> > --
> > David Portas
> > SQL Server MVP
> > --|||As the responses have shown, licensing questions are a minefield of "What
If?s". If in doubt, consult your vendor or a Microsoft representative.

I believe Greg may be correct that if you have something like a VPN, where
the total number of users in the system is restricted then Server/CAL
licensing may be used.

> what I'm not sure is what is the definition of a device? why should
> each desktop require a CAL when the only "device" (i.e. computer?)
> accessing SQL is the web server machine?

Why? Because that's the licensing model that Microsoft sells.

http://www.microsoft.com/sql/howtobuy/

"Regardless of how many tiers of hardware or software exist between the SQL
Server and the client devices that ultimately use its data, services, or
functionality, a CAL is required for each distinct input to the
multiplexing, pooling, or related software or the hardware front end.
Processor licensing will likely be the appropriate licensing option in these
situations, due to its simplicity and affordability."

--
David Portas
SQL Server MVP
--|||> Does that mean I cannot have a web application using MSDE as a backend
> database?
> If not, MSDE would be a good solution, given someone can live with the
> limitations.

"MSDE is an ideal solution for basic Web applications with up to 25
concurrent users."
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp

> Also, do you know, that's more of a Windos Server 2003 Web Edition
question
> but goes in the same direction:
> Microsoft says it's prohibited to install any applications on the Web
> Edition. Does this include MSDE 2000A?

I'm not familiar with 2003 Web Ed.

--
David Portas
SQL Server MVP
--|||Thanks David!

"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:MYydnQo9m70duJ_cRVn-rA@.giganews.com...
> > Does that mean I cannot have a web application using MSDE as a backend
> > database?
> > If not, MSDE would be a good solution, given someone can live with the
> > limitations.
> "MSDE is an ideal solution for basic Web applications with up to 25
> concurrent users."
> http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
>
> > Also, do you know, that's more of a Windos Server 2003 Web Edition
> question
> > but goes in the same direction:
> > Microsoft says it's prohibited to install any applications on the Web
> > Edition. Does this include MSDE 2000A?
> I'm not familiar with 2003 Web Ed.
> --
> David Portas
> SQL Server MVP
> --|||Martin Feuersteiner (theintrepidfox@.hotmail.com) writes:
> Also, do you know, that's more of a Windos Server 2003 Web Edition
> question but goes in the same direction: Microsoft says it's prohibited
> to install any applications on the Web Edition. Does this include MSDE
> 2000A?

You may install MSDE on Windows 2003 Web Edition. That is also the only
edition of SQL Server that you can install on Web Edition.

Since you say that it is not permitted to install applications on Web
Edition, I would guess that it is not permitted to install MSDE on your
Web Edition machine for any other purpose than to be the backend to
your web server.

But for a decisive answer on all licensing questions, it is best to ask
a Microsoft representative.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message news:<aI-dnS-uqfrXuZ_cRVn-iQ@.giganews.com>...
> As the responses have shown, licensing questions are a minefield of "What
> If?s". If in doubt, consult your vendor or a Microsoft representative.
> I believe Greg may be correct that if you have something like a VPN, where
> the total number of users in the system is restricted then Server/CAL
> licensing may be used.
> > what I'm not sure is what is the definition of a device? why should
> > each desktop require a CAL when the only "device" (i.e. computer?)
> > accessing SQL is the web server machine?
> Why? Because that's the licensing model that Microsoft sells.
> http://www.microsoft.com/sql/howtobuy/
> "Regardless of how many tiers of hardware or software exist between the SQL
> Server and the client devices that ultimately use its data, services, or
> functionality, a CAL is required for each distinct input to the
> multiplexing, pooling, or related software or the hardware front end.
> Processor licensing will likely be the appropriate licensing option in these
> situations, due to its simplicity and affordability."

Thanks, that's just the bit I was looking for (I wasn't arguing with
the licencing model, just looking for a deifinitive statement)

Device activation error problem, Index file missing

Hi, everybody.
I have a big problem. One of the disks in RAID 5 array went dead, and
our costumer's administrator tried to fix the problem, which he did, in
the end, but thet ment that all the data on that partition was lost. A
great way to fix the problem, don't you think? Unfortunately, on that
partition there was Index_data.ndf, file that I used for all the
indexes in my database, all the data is in the other file, on the other
partition. There's no backup bacause the database size is about 500GB:(
Now, database is in suspect mode, of course, and I'm thinking about my
options. I know there's a way to put database back from suspect mode
and transport the data using DTS or something to another db, but I'd
really love to skip the part where I get to transport manually 300 GB
of data from one db to another.
What I want to know is this: is there a way to delete indexes from
tables in database, or to delete the index file from database
properties so I could start database again, recreate index file and
recreate indexes?
Any halp is appreciated...
Regards,
MarkoOf course database size does not deteremine backups. Have them buy idera or
redgate. I backed up a 600GB DB to 20GB file with both, no fuss no muss.
On to your problem. Is this 2000? You can reset the suspect flag with
sp_resetstatus. Barring any other options, I would use that proc and then
try to get a backup even if you have to download red-gates eval tool. If you
have a good backup, attempt to drop all indexes located on the now missing
partition by generating a script or turning on ad-hoc updates to system
tables(2k only) and attempting to drop them from there(sysindexes). if you
can't get a reliable backup(ensure you can restore it before doing anything
permanent) once you have the db out of suspect mode, you might have to force
table scans wth queries to get data out as the missing indexes could play
hell with the optimizer and any tool you choose. Red-gate's suite may also
help here, saving you some legwork.
Lastly, slap the admin.
"Marko.Sunjic@.gmail.com" wrote:
> Hi, everybody.
> I have a big problem. One of the disks in RAID 5 array went dead, and
> our costumer's administrator tried to fix the problem, which he did, in
> the end, but thet ment that all the data on that partition was lost. A
> great way to fix the problem, don't you think? Unfortunately, on that
> partition there was Index_data.ndf, file that I used for all the
> indexes in my database, all the data is in the other file, on the other
> partition. There's no backup bacause the database size is about 500GB:(
> Now, database is in suspect mode, of course, and I'm thinking about my
> options. I know there's a way to put database back from suspect mode
> and transport the data using DTS or something to another db, but I'd
> really love to skip the part where I get to transport manually 300 GB
> of data from one db to another.
> What I want to know is this: is there a way to delete indexes from
> tables in database, or to delete the index file from database
> properties so I could start database again, recreate index file and
> recreate indexes?
> Any halp is appreciated...
> Regards,
> Marko
>

Device activation error

Hello,
I'm attempting to upgrade from MSDE 1.0 to MSDE 2000. However, before
removing MSDE 1.0, a database apparently was not properly detached after
attempting to attach (using sp_attach_db not attach w/ single file) this very
database to MSDE 2000.
The following error is rec'd:
"Can not create file C:\Program Files...\MyData.LDF because it already
exists.
Could not open new database "MyData". CREATE DATABASE is aborted.
Device activation error. The physical file name "C:\MSSQL7\Data\MyData.LDF
may be incorrect."
Should I attempt to place the log file back to its old location, restore the
database and then detach or should I try to shrink the file and truncate the
log?
Just want to know before I further screw things up.
any help is appreciated.
Hello,
If you have the latest backup then RESTORE the DATABASe using RESTORE
DATABASE WITH MOVE options..Try restoring using a new name and make sure
that
dataBase backup is good.
Thanks
Hari
"jim" <jim@.discussions.microsoft.com> wrote in message
news:F3BE2646-3666-40C7-AF83-763ED47957B2@.microsoft.com...
> Hello,
> I'm attempting to upgrade from MSDE 1.0 to MSDE 2000. However, before
> removing MSDE 1.0, a database apparently was not properly detached after
> attempting to attach (using sp_attach_db not attach w/ single file) this
> very
> database to MSDE 2000.
> The following error is rec'd:
> "Can not create file C:\Program Files...\MyData.LDF because it already
> exists.
> Could not open new database "MyData". CREATE DATABASE is aborted.
> Device activation error. The physical file name "C:\MSSQL7\Data\MyData.LDF
> may be incorrect."
> Should I attempt to place the log file back to its old location, restore
> the
> database and then detach or should I try to shrink the file and truncate
> the
> log?
> Just want to know before I further screw things up.
> any help is appreciated.
>
|||Hi Hari,
Thanks for the response. I just have one more question. With the new
database name, does this mean that the existing database name can no longer
be used on this computer? Or, once the database is restored, I can detach the
database w/ the new database name and then attach the database w/ the old
name in the new location? Hopefully, this question isn't too silly.
your help is appreciated.
"Hari Prasad" wrote:

> Hello,
> If you have the latest backup then RESTORE the DATABASe using RESTORE
> DATABASE WITH MOVE options..Try restoring using a new name and make sure
> that
> dataBase backup is good.
> Thanks
> Hari
> "jim" <jim@.discussions.microsoft.com> wrote in message
> news:F3BE2646-3666-40C7-AF83-763ED47957B2@.microsoft.com...
>
>

Device Activation Error

Dear All,
I have deployed a new SQL server and I have installed SP4, I have tried to
restore my old dbase using restore from device and I choosed the dbase file
name. I got the following error (Device activiation error. The physical name
'old dbase file path' ma be incorrect). Use WITH MOVE to identify a valid
location for the file.
Please helpppp
*********
IT Manager
DeLaval Ltd.
Cairo-Egypt
*********
|--|
|Islam is peace not Terror|
|--|
"Ibrahim Awwad" <ibrahim_awwad(at)hotmail(dot)com(antispam)> wrote in
message news:0AEA8F49-A25F-4DAC-B150-818FC9E94B99@.microsoft.com...
> Dear All,
> I have deployed a new SQL server and I have installed SP4, I have tried to
> restore my old dbase using restore from device and I choosed the dbase
> file
> name. I got the following error (Device activiation error. The physical
> name
> 'old dbase file path' ma be incorrect). Use WITH MOVE to identify a valid
> location for the file.
> Please helpppp
This means that one or more of the files the database is being restored to
already exists. Check the file name. If a file exists there, you might
want to rename it. Or, as the message indicates, use RESTORE ... WITH MOVE.
David
|||Hi David,
The files aren't there and I even tried to renave the dbase and the log file
but it didn't work. USE WITH MOVE it was in the warning message and I can't
find it at all in the restore options.
*********
IT Manager
DeLaval Ltd.
Cairo-Egypt
*********
|--|
|Islam is peace not Terror|
|--|
"David Browne" wrote:

> "Ibrahim Awwad" <ibrahim_awwad(at)hotmail(dot)com(antispam)> wrote in
> message news:0AEA8F49-A25F-4DAC-B150-818FC9E94B99@.microsoft.com...
>
> This means that one or more of the files the database is being restored to
> already exists. Check the file name. If a file exists there, you might
> want to rename it. Or, as the message indicates, use RESTORE ... WITH MOVE.
> David
>
>
|||> USE WITH MOVE it was in the warning message and I can't
> find it at all in the restore options.
Below is a Transact-SQL example of the MOVE option David suggested. The
drives/folders must exist but the file must not.
RESTORE DATABASE MyDatabase
FROM DISK='C:\Backups\MyDatabase.bak'
WITH
MOVE 'MyDatabase' TO 'E:\DataFiles\\MyDatabase.mdf',
MOVE 'MyDatabase_Log' TO 'F:\LogFiles\\MyDatabase_Log.ldf'
You can list the logical file names needed for the MOVE option with RESTORE
FILELISTONLY:
RESTORE FILELISTONLY
FROM DISK='C:\Backups\MyDatabase.bak'
Hope this helps.
Dan Guzman
SQL Server MVP
"Ibrahim Awwad" <ibrahim_awwad(at)hotmail(dot)com(antispam)> wrote in
message news:0B29F43E-C8ED-4B4B-B93E-5F85EE0DBF6A@.microsoft.com...[vbcol=seagreen]
> Hi David,
> The files aren't there and I even tried to renave the dbase and the log
> file
> but it didn't work. USE WITH MOVE it was in the warning message and I
> can't
> find it at all in the restore options.
> --
> *********
> IT Manager
> DeLaval Ltd.
> Cairo-Egypt
> *********
> |--|
> |Islam is peace not Terror|
> |--|
>
> "David Browne" wrote:

Device Activation Error

Dear All,
I have deployed a new SQL server and I have installed SP4, I have tried to
restore my old dbase using restore from device and I choosed the dbase file
name. I got the following error (Device activiation error. The physical name
'old dbase file path' ma be incorrect). Use WITH MOVE to identify a valid
location for the file.
Please helpppp
--
*********
IT Manager
DeLaval Ltd.
Cairo-Egypt
*********
|--|
|Islam is peace not Terror|
|--|"Ibrahim Awwad" <ibrahim_awwad(at)hotmail(dot)com(antispam)> wrote in
message news:0AEA8F49-A25F-4DAC-B150-818FC9E94B99@.microsoft.com...
> Dear All,
> I have deployed a new SQL server and I have installed SP4, I have tried to
> restore my old dbase using restore from device and I choosed the dbase
> file
> name. I got the following error (Device activiation error. The physical
> name
> 'old dbase file path' ma be incorrect). Use WITH MOVE to identify a valid
> location for the file.
> Please helpppp
This means that one or more of the files the database is being restored to
already exists. Check the file name. If a file exists there, you might
want to rename it. Or, as the message indicates, use RESTORE ... WITH MOVE.
David|||Hi David,
The files aren't there and I even tried to renave the dbase and the log file
but it didn't work. USE WITH MOVE it was in the warning message and I can't
find it at all in the restore options.
--
*********
IT Manager
DeLaval Ltd.
Cairo-Egypt
*********
|--|
|Islam is peace not Terror|
|--|
"David Browne" wrote:
> "Ibrahim Awwad" <ibrahim_awwad(at)hotmail(dot)com(antispam)> wrote in
> message news:0AEA8F49-A25F-4DAC-B150-818FC9E94B99@.microsoft.com...
> > Dear All,
> >
> > I have deployed a new SQL server and I have installed SP4, I have tried to
> > restore my old dbase using restore from device and I choosed the dbase
> > file
> > name. I got the following error (Device activiation error. The physical
> > name
> > 'old dbase file path' ma be incorrect). Use WITH MOVE to identify a valid
> > location for the file.
> >
> > Please helpppp
>
> This means that one or more of the files the database is being restored to
> already exists. Check the file name. If a file exists there, you might
> want to rename it. Or, as the message indicates, use RESTORE ... WITH MOVE.
> David
>
>|||> USE WITH MOVE it was in the warning message and I can't
> find it at all in the restore options.
Below is a Transact-SQL example of the MOVE option David suggested. The
drives/folders must exist but the file must not.
RESTORE DATABASE MyDatabase
FROM DISK='C:\Backups\MyDatabase.bak'
WITH
MOVE 'MyDatabase' TO 'E:\DataFiles\\MyDatabase.mdf',
MOVE 'MyDatabase_Log' TO 'F:\LogFiles\\MyDatabase_Log.ldf'
You can list the logical file names needed for the MOVE option with RESTORE
FILELISTONLY:
RESTORE FILELISTONLY
FROM DISK='C:\Backups\MyDatabase.bak'
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Ibrahim Awwad" <ibrahim_awwad(at)hotmail(dot)com(antispam)> wrote in
message news:0B29F43E-C8ED-4B4B-B93E-5F85EE0DBF6A@.microsoft.com...
> Hi David,
> The files aren't there and I even tried to renave the dbase and the log
> file
> but it didn't work. USE WITH MOVE it was in the warning message and I
> can't
> find it at all in the restore options.
> --
> *********
> IT Manager
> DeLaval Ltd.
> Cairo-Egypt
> *********
> |--|
> |Islam is peace not Terror|
> |--|
>
> "David Browne" wrote:
>> "Ibrahim Awwad" <ibrahim_awwad(at)hotmail(dot)com(antispam)> wrote in
>> message news:0AEA8F49-A25F-4DAC-B150-818FC9E94B99@.microsoft.com...
>> > Dear All,
>> >
>> > I have deployed a new SQL server and I have installed SP4, I have tried
>> > to
>> > restore my old dbase using restore from device and I choosed the dbase
>> > file
>> > name. I got the following error (Device activiation error. The physical
>> > name
>> > 'old dbase file path' ma be incorrect). Use WITH MOVE to identify a
>> > valid
>> > location for the file.
>> >
>> > Please helpppp
>>
>> This means that one or more of the files the database is being restored
>> to
>> already exists. Check the file name. If a file exists there, you might
>> want to rename it. Or, as the message indicates, use RESTORE ... WITH
>> MOVE.
>> David
>>

Device Activation Error

Hi,

I have set of stored procedures in SQL 7.0. They are all encrypted. I moved the whole set to SQL 2K. I took a backup of the SQL 7.0 version and put it in SQL 2K. Now, when I run the stored procedure in SQL 2K, I am getting an error as "Device Activation Error". This is happening when I run a stored procedure which is creating a new database and I am giving the MDF and LDF names as parameters. I have not met with any success in SQL Books. Please enlighten...

Thanks,
SrinidhiOriginally posted by srinidhiv
Hi,

I have set of stored procedures in SQL 7.0. They are all encrypted. I moved the whole set to SQL 2K. I took a backup of the SQL 7.0 version and put it in SQL 2K. Now, when I run the stored procedure in SQL 2K, I am getting an error as "Device Activation Error". This is happening when I run a stored procedure which is creating a new database and I am giving the MDF and LDF names as parameters. I have not met with any success in SQL Books. Please enlighten...

Thanks,
Srinidhi

what do you mean by encrypted stored procedures ?
if you could post the code ,it could be more helpful.|||Does the stored procedure works fine in SQLServer7.0 ?|||So your SP is encrypted. It is written with incompatible MSSQL7 syntax.
You can simply decrypt it. MSSQL2K encryption is weak.
Get permitions to rewrite SP from developer and look at I-net.

Device activation error

Hi All,

Currently I have a PC that has MSDE installed on it and is attached to database (MyData.MDF and a log file MYLog.LDF) located on its hard drive at c:\data\.When I detach from the database, place a copy of the two files noted above on my networkdrive @. u:\data and try to attach I get the following error’s:

SQL[1] exec error = -1: Changed database context to 'master'.

“Device activation error. The physical file name u:\data\MyData.MDF may be incorrect.”

I have done some testing a have found that I can attach to a copy of my database if I move it anywhere on the c: drive, and or even to a 1Gb USB key attached to the system(e:\).So far it seems to only be an issue if I move it to a mapped network drive.If anyone could please provide me with any info it would be greatly appreciated.

Thanks.

James D.

First, your data must be stored on an approved network server/storage you want to be supported. Second, you will have to use a special trace flag to force sqlserver to mount a networked db file. See the following article:
http://support.microsoft.com/kb/304261|||

It's because your U: drive isn't a local drive. By default, it's not support to place data files on mapped shares or UNC paths. You can find more information in the following article:

Description of support for network database files in SQL Server

http://support.microsoft.com/?id=304261

-Sue

|||

Excellent, thank you for the response.

After I use the trace flag mentioned and get my MS SQL Server Desktop Engine to mount to the networked db files, will it be possible to have a second PC with MS SQL Server Desktop Engine also installed on it to connect to the same networked DB files at the same time as the first unit, or will it be limited to just one PC at a time due to file locks? We require that at least two units(possibly up to 3 more in the future) can all share, write, and read to same networked db files at the same time. If you could please let me know when you have a moment it would be great.

Thanks.

James D.

|||

Sqlserver is a shared nothing technology. I.e. only one instance can access the data at any time. So, no, you cannot have another server hits that network database file(s). As it stands, unless your hardware is part of the qualified HCL, you're running in an unsupported platform.

Btw, sqlserver has a feature called Scalable Shared Database (SSD) which allows multiple instances to share the same database file. However, this requires a SAN.

Device Activation Error

Dear All,
I have deployed a new SQL server and I have installed SP4, I have tried to
restore my old dbase using restore from device and I choosed the dbase file
name. I got the following error (Device activiation error. The physical name
'old dbase file path' ma be incorrect). Use WITH MOVE to identify a valid
location for the file.
Please helpppp
--
*********
IT Manager
DeLaval Ltd.
Cairo-Egypt
*********
|--|
|Islam is peace not Terror|
|--|"Ibrahim Awwad" < ibrahim_awwad(at)hotmail(dot)com(antispa
m)> wrote in
message news:0AEA8F49-A25F-4DAC-B150-818FC9E94B99@.microsoft.com...
> Dear All,
> I have deployed a new SQL server and I have installed SP4, I have tried to
> restore my old dbase using restore from device and I choosed the dbase
> file
> name. I got the following error (Device activiation error. The physical
> name
> 'old dbase file path' ma be incorrect). Use WITH MOVE to identify a valid
> location for the file.
> Please helpppp
This means that one or more of the files the database is being restored to
already exists. Check the file name. If a file exists there, you might
want to rename it. Or, as the message indicates, use RESTORE ... WITH MOVE.
David|||Hi David,
The files aren't there and I even tried to renave the dbase and the log file
but it didn't work. USE WITH MOVE it was in the warning message and I can't
find it at all in the restore options.
--
*********
IT Manager
DeLaval Ltd.
Cairo-Egypt
*********
|--|
|Islam is peace not Terror|
|--|
"David Browne" wrote:

> "Ibrahim Awwad" < ibrahim_awwad(at)hotmail(dot)com(antispa
m)> wrote in
> message news:0AEA8F49-A25F-4DAC-B150-818FC9E94B99@.microsoft.com...
>
> This means that one or more of the files the database is being restored to
> already exists. Check the file name. If a file exists there, you might
> want to rename it. Or, as the message indicates, use RESTORE ... WITH MOV
E.
> David
>
>|||> USE WITH MOVE it was in the warning message and I can't
> find it at all in the restore options.
Below is a Transact-SQL example of the MOVE option David suggested. The
drives/folders must exist but the file must not.
RESTORE DATABASE MyDatabase
FROM DISK='C:\Backups\MyDatabase.bak'
WITH
MOVE 'MyDatabase' TO 'E:\DataFiles\\MyDatabase.mdf',
MOVE 'MyDatabase_Log' TO 'F:\LogFiles\\MyDatabase_Log.ldf'
You can list the logical file names needed for the MOVE option with RESTORE
FILELISTONLY:
RESTORE FILELISTONLY
FROM DISK='C:\Backups\MyDatabase.bak'
Hope this helps.
Dan Guzman
SQL Server MVP
"Ibrahim Awwad" < ibrahim_awwad(at)hotmail(dot)com(antispa
m)> wrote in
message news:0B29F43E-C8ED-4B4B-B93E-5F85EE0DBF6A@.microsoft.com...[vbcol=seagreen]
> Hi David,
> The files aren't there and I even tried to renave the dbase and the log
> file
> but it didn't work. USE WITH MOVE it was in the warning message and I
> can't
> find it at all in the restore options.
> --
> *********
> IT Manager
> DeLaval Ltd.
> Cairo-Egypt
> *********
> |--|
> |Islam is peace not Terror|
> |--|
>
> "David Browne" wrote:
>