Restore mdf file: tape

Showing posts with label tape. Show all posts

Monday, March 26, 2012

RESTORE DATABASE question

Hi,
In my SQL Server 2000,
RESTORE DATABASE ETCService
FROM TAPE = '\\.\Tape0'
it gave me an error saying I have no right to do the Restore.
What kind of privilege do I need for doing the Restore Database?
Thanks for help.
JasonIt depends on whether the database you want to restore already exist or not.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jason Huang" <JasonHuang8888@.hotmail.com> wrote in message
news:OWpIs%234EHHA.3780@.TK2MSFTNGP02.phx.gbl...
> Hi,
> In my SQL Server 2000,
> RESTORE DATABASE ETCService
> FROM TAPE = '\\.\Tape0'
> it gave me an error saying I have no right to do the Restore.
> What kind of privilege do I need for doing the Restore Database?
> Thanks for help.
>
> Jason
>|||Thanks Tibor.
It's already existed!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> ¼¶¼g©ó¶l¥ó·s»D:uRmHKJ5EHHA.3932@.TK2MSFTNGP02.phx.gbl...
> It depends on whether the database you want to restore already exist or
> not.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Jason Huang" <JasonHuang8888@.hotmail.com> wrote in message
> news:OWpIs%234EHHA.3780@.TK2MSFTNGP02.phx.gbl...
>> Hi,
>> In my SQL Server 2000,
>> RESTORE DATABASE ETCService
>> FROM TAPE = '\\.\Tape0'
>> it gave me an error saying I have no right to do the Restore.
>> What kind of privilege do I need for doing the Restore Database?
>> Thanks for help.
>>
>> Jason
>|||Jason
Are you a member of sysadmin server role dbcreator fixed server role?
Probably not, am I right?
db_owner fixed database role do not have RESTORE permissions.
"Jason Huang" <JasonHuang8888@.hotmail.com> wrote in message
news:ez1JmU5EHHA.3540@.TK2MSFTNGP02.phx.gbl...
> Thanks Tibor.
> It's already existed!
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
> ¼¶¼g©ó¶l¥ó·s»D:uRmHKJ5EHHA.3932@.TK2MSFTNGP02.phx.gbl...
>> It depends on whether the database you want to restore already exist or
>> not.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Jason Huang" <JasonHuang8888@.hotmail.com> wrote in message
>> news:OWpIs%234EHHA.3780@.TK2MSFTNGP02.phx.gbl...
>> Hi,
>> In my SQL Server 2000,
>> RESTORE DATABASE ETCService
>> FROM TAPE = '\\.\Tape0'
>> it gave me an error saying I have no right to do the Restore.
>> What kind of privilege do I need for doing the Restore Database?
>> Thanks for help.
>>
>> Jason
>>
>|||Here's a section from Books Online, RESTORE DATABASE, Permissions:
"If the database being restored does not exist, the user must have CREATE DATABASE permissions to be
able to execute RESTORE. If the database exists, RESTORE permissions default to members of the
sysadmin and dbcreator fixed server roles and the owner (dbo) of the database (for the FROM
DATABASE_SNAPSHOT option, the database always exists).
RESTORE permissions are given to roles in which membership information is always readily available
to the server. Because fixed database role membership can be checked only when the database is
accessible and undamaged, which is not always the case when RESTORE is executed, members of the
db_owner fixed database role do not have RESTORE permissions."
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jason Huang" <JasonHuang8888@.hotmail.com> wrote in message
news:ez1JmU5EHHA.3540@.TK2MSFTNGP02.phx.gbl...
> Thanks Tibor.
> It's already existed!
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
> ¼¶¼g©ó¶l¥ó·s»D:uRmHKJ5EHHA.3932@.TK2MSFTNGP02.phx.gbl...
>> It depends on whether the database you want to restore already exist or not.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Jason Huang" <JasonHuang8888@.hotmail.com> wrote in message
>> news:OWpIs%234EHHA.3780@.TK2MSFTNGP02.phx.gbl...
>> Hi,
>> In my SQL Server 2000,
>> RESTORE DATABASE ETCService
>> FROM TAPE = '\\.\Tape0'
>> it gave me an error saying I have no right to do the Restore.
>> What kind of privilege do I need for doing the Restore Database?
>> Thanks for help.
>>
>> Jason
>>
>

RESTORE DATABASE question

Hi,
In my SQL Server 2000,
RESTORE DATABASE ETCService
FROM TAPE = '\\.\Tape0'
it gave me an error saying I have no right to do the Restore.
What kind of privilege do I need for doing the Restore Database?
Thanks for help.
Jason
Thanks Tibor.
It's already existed!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> glsD:uRmHKJ5EHHA.3932@.TK2MSFTNGP02.phx.g bl...
> It depends on whether the database you want to restore already exist or
> not.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Jason Huang" <JasonHuang8888@.hotmail.com> wrote in message
> news:OWpIs%234EHHA.3780@.TK2MSFTNGP02.phx.gbl...
>
|||Jason
Are you a member of sysadmin server role dbcreator fixed server role?
Probably not, am I right?
db_owner fixed database role do not have RESTORE permissions.
"Jason Huang" <JasonHuang8888@.hotmail.com> wrote in message
news:ez1JmU5EHHA.3540@.TK2MSFTNGP02.phx.gbl...
> Thanks Tibor.
> It's already existed!
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
> glsD:uRmHKJ5EHHA.3932@.TK2MSFTNGP02.phx.g bl...
>

RESTORE DATABASE question

Monday, March 12, 2012

Restore cold backup of database files

I have some questions.
A customer had a drive crash on their win2003 server running mssql
2000. I have a full backup to tape but it's a day old. I was able to
get a copy of the database files off the server before it crashed all
the way. I will be reinstalling win2003 and sqlserver.
My question is can I copy the database files back into the dirctory and
have the new install of mssql 'see' my database?
Thanks,
David
Yes, you can use the stored procedure, sp_attach_db, to attach the database
files.
You may also need to fix any orphaned users in the database. See the topic
"Troubleshooting Orphaned Users" in Books Online.
David Portas
SQL Server MVP
|||In addition to David's comments you may find these useful:
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
<daviddnv@.yahoo.com> wrote in message
news:1103406101.650789.272580@.c13g2000cwb.googlegr oups.com...
>I have some questions.
> A customer had a drive crash on their win2003 server running mssql
> 2000. I have a full backup to tape but it's a day old. I was able to
> get a copy of the database files off the server before it crashed all
> the way. I will be reinstalling win2003 and sqlserver.
> My question is can I copy the database files back into the dirctory and
> have the new install of mssql 'see' my database?
> Thanks,
> David
>

Restore cold backup of database files

I have some questions.
A customer had a drive crash on their win2003 server running mssql
2000. I have a full backup to tape but it's a day old. I was able to
get a copy of the database files off the server before it crashed all
the way. I will be reinstalling win2003 and sqlserver.
My question is can I copy the database files back into the dirctory and
have the new install of mssql 'see' my database?
Thanks,
DavidYes, you can use the stored procedure, sp_attach_db, to attach the database
files.
You may also need to fix any orphaned users in the database. See the topic
"Troubleshooting Orphaned Users" in Books Online.
--
David Portas
SQL Server MVP
--|||In addition to David's comments you may find these useful:
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
<daviddnv@.yahoo.com> wrote in message
news:1103406101.650789.272580@.c13g2000cwb.googlegroups.com...
>I have some questions.
> A customer had a drive crash on their win2003 server running mssql
> 2000. I have a full backup to tape but it's a day old. I was able to
> get a copy of the database files off the server before it crashed all
> the way. I will be reinstalling win2003 and sqlserver.
> My question is can I copy the database files back into the dirctory and
> have the new install of mssql 'see' my database?
> Thanks,
> David
>

Tuesday, February 21, 2012

Restore ...

1. I backedup databases from mssql7 default pathname with default pathname onto
tape.
2. I installed sql 2000 server onto another computer.
3. I restored data into the default directory that was created with MSSQL7
c:\...\MSSQL7\... from tape created in step 1.
4. In Enterprise Manager for sql 2000, I do see default databases. But I
don't see the ones I restored.
5. How can I view the databases I backed up in step 1? I have over 50
databases.
Thank you for your help!
-Me"Me" <Me@.discussions.microsoft.com> wrote in message
news:5AAF668E-EACB-422E-8F64-5B4AB1DE0EB5@.microsoft.com...
> 1. I backedup databases from mssql7 default pathname with default pathname
> onto
> tape.
> 2. I installed sql 2000 server onto another computer.
> 3. I restored data into the default directory that was created with MSSQL7
> c:\...\MSSQL7\... from tape created in step 1.
> 4. In Enterprise Manager for sql 2000, I do see default databases. But I
> don't see the ones I restored.
> 5. How can I view the databases I backed up in step 1? I have over 50
> databases.
sp_attach_db
> Thank you for your help!
> -Me
>
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||In article <OcYIPMnjHHA.3472@.TK2MSFTNGP04.phx.gbl>,
mooregr_deleteth1s@.greenms.com says...
> "Me" <Me@.discussions.microsoft.com> wrote in message
> news:5AAF668E-EACB-422E-8F64-5B4AB1DE0EB5@.microsoft.com...
> > 1. I backedup databases from mssql7 default pathname with default pathname
> > onto
> > tape.
> > 2. I installed sql 2000 server onto another computer.
> > 3. I restored data into the default directory that was created with MSSQL7
> > c:\...\MSSQL7\... from tape created in step 1.
> > 4. In Enterprise Manager for sql 2000, I do see default databases. But I
> > don't see the ones I restored.
> > 5. How can I view the databases I backed up in step 1? I have over 50
> > databases.
> sp_attach_db
>
> >
> > Thank you for your help!
> > -Me
> >
> >
> >
>
>
actually several of them -- max of 16 per execution IIRC. Check out BOL
for more info
--
Graham (Pete) Berry
PeteBerry@.CalTech.edu

Monday, March 26, 2012

RESTORE DATABASE question

RESTORE DATABASE question

RESTORE DATABASE question

Monday, March 12, 2012

Restore cold backup of database files

Restore cold backup of database files

Tuesday, February 21, 2012

Restore ...

Restore mdf file

Blog Archive

About Me