I have my SQL 2000 server running on W2003 Server
Logged in as domain admin
I want to do a manual backup of my database
So I follow the Microsoft document
Open Enterprise Manager, right click the database, all tasks, backeup
database, select full backup, add destination (I choose the default file
location C:\ ProgramdFiles\SQL Servere etc. - as I don't have a backup
device)
I get a warning 'the filename specified is recognised as a directory name.
The file won't be able to be rewritten. Do you wish to continue?'
I select OK
I then get an error '(ODBC SQLState 42000) Cannot open the backup device
C:\Program Files\etc.' Device error or device offline. See the SQL server log
for more details'
The eventlog error is '17055' Source' MSSQLServer' '3041 :
BACKUP failed to complete the command BACKUP DATABASE [DATASTORE] TO DISK =
N'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\' WITH NOINIT ,
NOUNLOAD , NAME = N'DATASTORE backup', NOSKIP , STATS = 10, NOFORMAT '
Any ideas anyone please !?!
why wouldn't you specify full file name (for example : C:\Program
Files\Microsoft SQL Server\MSSQL\BACKUP\DATASTORE.BAK ) ?
"goundhog" <goundhog@.discussions.microsoft.com> wrote in message
news:2B0D39F7-0324-4C8C-B22B-0F70BDD8E530@.microsoft.com...
>I have my SQL 2000 server running on W2003 Server
> Logged in as domain admin
> I want to do a manual backup of my database
> So I follow the Microsoft document
> Open Enterprise Manager, right click the database, all tasks, backeup
> database, select full backup, add destination (I choose the default file
> location C:\ ProgramdFiles\SQL Servere etc. - as I don't have a backup
> device)
> I get a warning 'the filename specified is recognised as a directory name.
> The file won't be able to be rewritten. Do you wish to continue?'
> I select OK
> I then get an error '(ODBC SQLState 42000) Cannot open the backup device
> C:\Program Files\etc.' Device error or device offline. See the SQL server
> log
> for more details'
> The eventlog error is '17055' Source' MSSQLServer' '3041 :
> BACKUP failed to complete the command BACKUP DATABASE [DATASTORE] TO DISK
> =
> N'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\' WITH NOINIT ,
> NOUNLOAD , NAME = N'DATASTORE backup', NOSKIP , STATS = 10, NOFORMAT '
>
> Any ideas anyone please !?!
>
Showing posts with label domain. Show all posts
Showing posts with label domain. Show all posts
Wednesday, March 28, 2012
Newbie question about SQL 2000 backup
I have my SQL 2000 server running on W2003 Server
Logged in as domain admin
I want to do a manual backup of my database
So I follow the Microsoft document
Open Enterprise Manager, right click the database, all tasks, backeup
database, select full backup, add destination (I choose the default file
location C:\ ProgramdFiles\SQL Servere etc. - as I don't have a backup
device)
I get a warning 'the filename specified is recognised as a directory name.
The file won't be able to be rewritten. Do you wish to continue?'
I select OK
I then get an error '(ODBC SQLState 42000) Cannot open the backup device
C:\Program Files\etc.' Device error or device offline. See the SQL server lo
g
for more details'
The eventlog error is '17055' Source' MSSQLServer' '3041 :
BACKUP failed to complete the command BACKUP DATABASE [DATASTORE] TO DI
SK =
N'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP' WITH NOINIT ,
NOUNLOAD , NAME = N'DATASTORE backup', NOSKIP , STATS = 10, NOFORMAT '
Any ideas anyone please !?!why wouldn't you specify full file name (for example : C:\Program
Files\Microsoft SQL Server\MSSQL\BACKUP\DATASTORE.BAK ) ?
"goundhog" <goundhog@.discussions.microsoft.com> wrote in message
news:2B0D39F7-0324-4C8C-B22B-0F70BDD8E530@.microsoft.com...
>I have my SQL 2000 server running on W2003 Server
> Logged in as domain admin
> I want to do a manual backup of my database
> So I follow the Microsoft document
> Open Enterprise Manager, right click the database, all tasks, backeup
> database, select full backup, add destination (I choose the default file
> location C:\ ProgramdFiles\SQL Servere etc. - as I don't have a backup
> device)
> I get a warning 'the filename specified is recognised as a directory name.
> The file won't be able to be rewritten. Do you wish to continue?'
> I select OK
> I then get an error '(ODBC SQLState 42000) Cannot open the backup device
> C:\Program Files\etc.' Device error or device offline. See the SQL server
> log
> for more details'
> The eventlog error is '17055' Source' MSSQLServer' '3041 :
> BACKUP failed to complete the command BACKUP DATABASE [DATASTORE] TO
DISK
> =
> N'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP' WITH NOINIT ,
> NOUNLOAD , NAME = N'DATASTORE backup', NOSKIP , STATS = 10, NOFORMAT '
>
> Any ideas anyone please !?!
>
Logged in as domain admin
I want to do a manual backup of my database
So I follow the Microsoft document
Open Enterprise Manager, right click the database, all tasks, backeup
database, select full backup, add destination (I choose the default file
location C:\ ProgramdFiles\SQL Servere etc. - as I don't have a backup
device)
I get a warning 'the filename specified is recognised as a directory name.
The file won't be able to be rewritten. Do you wish to continue?'
I select OK
I then get an error '(ODBC SQLState 42000) Cannot open the backup device
C:\Program Files\etc.' Device error or device offline. See the SQL server lo
g
for more details'
The eventlog error is '17055' Source' MSSQLServer' '3041 :
BACKUP failed to complete the command BACKUP DATABASE [DATASTORE] TO DI
SK =
N'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP' WITH NOINIT ,
NOUNLOAD , NAME = N'DATASTORE backup', NOSKIP , STATS = 10, NOFORMAT '
Any ideas anyone please !?!why wouldn't you specify full file name (for example : C:\Program
Files\Microsoft SQL Server\MSSQL\BACKUP\DATASTORE.BAK ) ?
"goundhog" <goundhog@.discussions.microsoft.com> wrote in message
news:2B0D39F7-0324-4C8C-B22B-0F70BDD8E530@.microsoft.com...
>I have my SQL 2000 server running on W2003 Server
> Logged in as domain admin
> I want to do a manual backup of my database
> So I follow the Microsoft document
> Open Enterprise Manager, right click the database, all tasks, backeup
> database, select full backup, add destination (I choose the default file
> location C:\ ProgramdFiles\SQL Servere etc. - as I don't have a backup
> device)
> I get a warning 'the filename specified is recognised as a directory name.
> The file won't be able to be rewritten. Do you wish to continue?'
> I select OK
> I then get an error '(ODBC SQLState 42000) Cannot open the backup device
> C:\Program Files\etc.' Device error or device offline. See the SQL server
> log
> for more details'
> The eventlog error is '17055' Source' MSSQLServer' '3041 :
> BACKUP failed to complete the command BACKUP DATABASE [DATASTORE] TO
DISK
> =
> N'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP' WITH NOINIT ,
> NOUNLOAD , NAME = N'DATASTORE backup', NOSKIP , STATS = 10, NOFORMAT '
>
> Any ideas anyone please !?!
>
Newbie question about SQL 2000 backup
I have my SQL 2000 server running on W2003 Server
Logged in as domain admin
I want to do a manual backup of my database
So I follow the Microsoft document
Open Enterprise Manager, right click the database, all tasks, backeup
database, select full backup, add destination (I choose the default file
location C:\ ProgramdFiles\SQL Servere etc. - as I don't have a backup
device)
I get a warning 'the filename specified is recognised as a directory name.
The file won't be able to be rewritten. Do you wish to continue?'
I select OK
I then get an error '(ODBC SQLState 42000) Cannot open the backup device
C:\Program Files\etc.' Device error or device offline. See the SQL server log
for more details'
The eventlog error is '17055' Source' MSSQLServer' '3041 :
BACKUP failed to complete the command BACKUP DATABASE [DATASTORE] TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\' WITH NOINIT ,
NOUNLOAD , NAME = N'DATASTORE backup', NOSKIP , STATS = 10, NOFORMAT '
Any ideas anyone please !?!why wouldn't you specify full file name (for example : C:\Program
Files\Microsoft SQL Server\MSSQL\BACKUP\DATASTORE.BAK ) ?
"goundhog" <goundhog@.discussions.microsoft.com> wrote in message
news:2B0D39F7-0324-4C8C-B22B-0F70BDD8E530@.microsoft.com...
>I have my SQL 2000 server running on W2003 Server
> Logged in as domain admin
> I want to do a manual backup of my database
> So I follow the Microsoft document
> Open Enterprise Manager, right click the database, all tasks, backeup
> database, select full backup, add destination (I choose the default file
> location C:\ ProgramdFiles\SQL Servere etc. - as I don't have a backup
> device)
> I get a warning 'the filename specified is recognised as a directory name.
> The file won't be able to be rewritten. Do you wish to continue?'
> I select OK
> I then get an error '(ODBC SQLState 42000) Cannot open the backup device
> C:\Program Files\etc.' Device error or device offline. See the SQL server
> log
> for more details'
> The eventlog error is '17055' Source' MSSQLServer' '3041 :
> BACKUP failed to complete the command BACKUP DATABASE [DATASTORE] TO DISK
> => N'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\' WITH NOINIT ,
> NOUNLOAD , NAME = N'DATASTORE backup', NOSKIP , STATS = 10, NOFORMAT '
>
> Any ideas anyone please !?!
>sql
Logged in as domain admin
I want to do a manual backup of my database
So I follow the Microsoft document
Open Enterprise Manager, right click the database, all tasks, backeup
database, select full backup, add destination (I choose the default file
location C:\ ProgramdFiles\SQL Servere etc. - as I don't have a backup
device)
I get a warning 'the filename specified is recognised as a directory name.
The file won't be able to be rewritten. Do you wish to continue?'
I select OK
I then get an error '(ODBC SQLState 42000) Cannot open the backup device
C:\Program Files\etc.' Device error or device offline. See the SQL server log
for more details'
The eventlog error is '17055' Source' MSSQLServer' '3041 :
BACKUP failed to complete the command BACKUP DATABASE [DATASTORE] TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\' WITH NOINIT ,
NOUNLOAD , NAME = N'DATASTORE backup', NOSKIP , STATS = 10, NOFORMAT '
Any ideas anyone please !?!why wouldn't you specify full file name (for example : C:\Program
Files\Microsoft SQL Server\MSSQL\BACKUP\DATASTORE.BAK ) ?
"goundhog" <goundhog@.discussions.microsoft.com> wrote in message
news:2B0D39F7-0324-4C8C-B22B-0F70BDD8E530@.microsoft.com...
>I have my SQL 2000 server running on W2003 Server
> Logged in as domain admin
> I want to do a manual backup of my database
> So I follow the Microsoft document
> Open Enterprise Manager, right click the database, all tasks, backeup
> database, select full backup, add destination (I choose the default file
> location C:\ ProgramdFiles\SQL Servere etc. - as I don't have a backup
> device)
> I get a warning 'the filename specified is recognised as a directory name.
> The file won't be able to be rewritten. Do you wish to continue?'
> I select OK
> I then get an error '(ODBC SQLState 42000) Cannot open the backup device
> C:\Program Files\etc.' Device error or device offline. See the SQL server
> log
> for more details'
> The eventlog error is '17055' Source' MSSQLServer' '3041 :
> BACKUP failed to complete the command BACKUP DATABASE [DATASTORE] TO DISK
> => N'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\' WITH NOINIT ,
> NOUNLOAD , NAME = N'DATASTORE backup', NOSKIP , STATS = 10, NOFORMAT '
>
> Any ideas anyone please !?!
>sql
Friday, March 23, 2012
newbie question
Hello,
I am studying for my exam and I have a question. I have a sql server
in a domain and when the domain administrator tries to access it, he
has no problems!! But in the literature it says that a domain
administrator must be in a group that has access to the sql server in
order to connect to that server, which is not the case? Does it have
somehing to do with the builtin\administrator account?
Kind regards,
Nico
Yes. By default, a domain admin will get added to the local admin group when
the box joins the domain. That means a domain admin is part of the
builtin\admin group. Thus, he/she has full access to sqlserver.
"Nico" <nico.barbe@.mobiusREMOVEFORSPAM.be> wrote in message
news:eZXCly2jEHA.596@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I am studying for my exam and I have a question. I have a sql server
> in a domain and when the domain administrator tries to access it, he
> has no problems!! But in the literature it says that a domain
> administrator must be in a group that has access to the sql server in
> order to connect to that server, which is not the case? Does it have
> somehing to do with the builtin\administrator account?
> Kind regards,
> Nico
|||By default, domain admin will be a member of local Administrators group
which essentially maps to BUILTIN\ADMIN account on SQL Server. However if
for some reason, someone has disabled or removed the builtin\admin account
from SQL, if the domain admin is part of another group on the server, and
if that other group is a registered user within SQL Server, then the domain
admin will have access to SQL through this other group even if
builtin\admin is disabled or removed.
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
I am studying for my exam and I have a question. I have a sql server
in a domain and when the domain administrator tries to access it, he
has no problems!! But in the literature it says that a domain
administrator must be in a group that has access to the sql server in
order to connect to that server, which is not the case? Does it have
somehing to do with the builtin\administrator account?
Kind regards,
Nico
Yes. By default, a domain admin will get added to the local admin group when
the box joins the domain. That means a domain admin is part of the
builtin\admin group. Thus, he/she has full access to sqlserver.
"Nico" <nico.barbe@.mobiusREMOVEFORSPAM.be> wrote in message
news:eZXCly2jEHA.596@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I am studying for my exam and I have a question. I have a sql server
> in a domain and when the domain administrator tries to access it, he
> has no problems!! But in the literature it says that a domain
> administrator must be in a group that has access to the sql server in
> order to connect to that server, which is not the case? Does it have
> somehing to do with the builtin\administrator account?
> Kind regards,
> Nico
|||By default, domain admin will be a member of local Administrators group
which essentially maps to BUILTIN\ADMIN account on SQL Server. However if
for some reason, someone has disabled or removed the builtin\admin account
from SQL, if the domain admin is part of another group on the server, and
if that other group is a registered user within SQL Server, then the domain
admin will have access to SQL through this other group even if
builtin\admin is disabled or removed.
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
newbie question
Hello,
I am studying for my exam and I have a question. I have a sql server
in a domain and when the domain administrator tries to access it, he
has no problems!! But in the literature it says that a domain
administrator must be in a group that has access to the sql server in
order to connect to that server, which is not the case? Does it have
somehing to do with the builtin\administrator account?
Kind regards,
NicoYes. By default, a domain admin will get added to the local admin group when
the box joins the domain. That means a domain admin is part of the
builtin\admin group. Thus, he/she has full access to sqlserver.
"Nico" <nico.barbe@.mobiusREMOVEFORSPAM.be> wrote in message
news:eZXCly2jEHA.596@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I am studying for my exam and I have a question. I have a sql server
> in a domain and when the domain administrator tries to access it, he
> has no problems!! But in the literature it says that a domain
> administrator must be in a group that has access to the sql server in
> order to connect to that server, which is not the case? Does it have
> somehing to do with the builtin\administrator account?
> Kind regards,
> Nico|||By default, domain admin will be a member of local Administrators group
which essentially maps to BUILTIN\ADMIN account on SQL Server. However if
for some reason, someone has disabled or removed the builtin\admin account
from SQL, if the domain admin is part of another group on the server, and
if that other group is a registered user within SQL Server, then the domain
admin will have access to SQL through this other group even if
builtin\admin is disabled or removed.
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.sql
I am studying for my exam and I have a question. I have a sql server
in a domain and when the domain administrator tries to access it, he
has no problems!! But in the literature it says that a domain
administrator must be in a group that has access to the sql server in
order to connect to that server, which is not the case? Does it have
somehing to do with the builtin\administrator account?
Kind regards,
NicoYes. By default, a domain admin will get added to the local admin group when
the box joins the domain. That means a domain admin is part of the
builtin\admin group. Thus, he/she has full access to sqlserver.
"Nico" <nico.barbe@.mobiusREMOVEFORSPAM.be> wrote in message
news:eZXCly2jEHA.596@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I am studying for my exam and I have a question. I have a sql server
> in a domain and when the domain administrator tries to access it, he
> has no problems!! But in the literature it says that a domain
> administrator must be in a group that has access to the sql server in
> order to connect to that server, which is not the case? Does it have
> somehing to do with the builtin\administrator account?
> Kind regards,
> Nico|||By default, domain admin will be a member of local Administrators group
which essentially maps to BUILTIN\ADMIN account on SQL Server. However if
for some reason, someone has disabled or removed the builtin\admin account
from SQL, if the domain admin is part of another group on the server, and
if that other group is a registered user within SQL Server, then the domain
admin will have access to SQL through this other group even if
builtin\admin is disabled or removed.
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.sql
newbie question
Hello,
I am studying for my exam and I have a question. I have a sql server
in a domain and when the domain administrator tries to access it, he
has no problems!! But in the literature it says that a domain
administrator must be in a group that has access to the sql server in
order to connect to that server, which is not the case? Does it have
somehing to do with the builtin\administrator account?
Kind regards,
NicoYes. By default, a domain admin will get added to the local admin group when
the box joins the domain. That means a domain admin is part of the
builtin\admin group. Thus, he/she has full access to sqlserver.
"Nico" <nico.barbe@.mobiusREMOVEFORSPAM.be> wrote in message
news:eZXCly2jEHA.596@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I am studying for my exam and I have a question. I have a sql server
> in a domain and when the domain administrator tries to access it, he
> has no problems!! But in the literature it says that a domain
> administrator must be in a group that has access to the sql server in
> order to connect to that server, which is not the case? Does it have
> somehing to do with the builtin\administrator account?
> Kind regards,
> Nico|||By default, domain admin will be a member of local Administrators group
which essentially maps to BUILTIN\ADMIN account on SQL Server. However if
for some reason, someone has disabled or removed the builtin\admin account
from SQL, if the domain admin is part of another group on the server, and
if that other group is a registered user within SQL Server, then the domain
admin will have access to SQL through this other group even if
builtin\admin is disabled or removed.
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
I am studying for my exam and I have a question. I have a sql server
in a domain and when the domain administrator tries to access it, he
has no problems!! But in the literature it says that a domain
administrator must be in a group that has access to the sql server in
order to connect to that server, which is not the case? Does it have
somehing to do with the builtin\administrator account?
Kind regards,
NicoYes. By default, a domain admin will get added to the local admin group when
the box joins the domain. That means a domain admin is part of the
builtin\admin group. Thus, he/she has full access to sqlserver.
"Nico" <nico.barbe@.mobiusREMOVEFORSPAM.be> wrote in message
news:eZXCly2jEHA.596@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I am studying for my exam and I have a question. I have a sql server
> in a domain and when the domain administrator tries to access it, he
> has no problems!! But in the literature it says that a domain
> administrator must be in a group that has access to the sql server in
> order to connect to that server, which is not the case? Does it have
> somehing to do with the builtin\administrator account?
> Kind regards,
> Nico|||By default, domain admin will be a member of local Administrators group
which essentially maps to BUILTIN\ADMIN account on SQL Server. However if
for some reason, someone has disabled or removed the builtin\admin account
from SQL, if the domain admin is part of another group on the server, and
if that other group is a registered user within SQL Server, then the domain
admin will have access to SQL through this other group even if
builtin\admin is disabled or removed.
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
Subscribe to:
Posts (Atom)