How can I restore a SQL 6.5 database backup to a SQL 7.0/2000 server?

Thanks,
Pedro Rodrigues
pedro@.markdata.ptYou can't. You need to get it into a 6.5 SQL Server and then use the Upgrade
Wizard that comes with 7.0 (and 2000) to get the data over to 7.0/2000.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Pedro Cunha Rodrigues" <pedro@.markdata.pt> wrote in message
news:OWmocMnvDHA.2340@.TK2MSFTNGP12.phx.gbl...
> Thanks,
> Pedro Rodrigues
> pedro@.markdata.pt
>

How can I restore a SQL 6.5 database backup to a SQL 7.0/2000 server?

Thanks,
Pedro Rodrigues
pedro@.markdata.ptYou can't. You need to get it into a 6.5 SQL Server and then use the Upgrade
Wizard that comes with 7.0 (and 2000) to get the data over to 7.0/2000.
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Pedro Cunha Rodrigues" <pedro@.markdata.pt> wrote in message
news:OWmocMnvDHA.2340@.TK2MSFTNGP12.phx.gbl...

quote:

---

> Thanks,
> Pedro Rodrigues
> pedro@.markdata.pt
>

---

how can i regenerate Database from my Backup file ? ?

hello All !!

i have taken mybackup(back file ) of database and i stored in folder , now i want to know

1)if i format my Hard Disk . and reinstall Sql server 2000 ?

2) if i delete that Database ?

how can i REGENERATE my database ?? again

thnk u all

In case you just have the backup somewhere safe / available after you have done / faced with 1) and/or 2), you can just restore the database from the .bak file.

SQl Server 2000 Backup And Restore
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx

How Can I reduce my transacion log file?

I Have a Database with a transaction log file 31 Gb, and I have problem to
backup it.
I want decresea it but don't remember How.
LorenaHi,
It seems you have set recovery model for this database to FULL. In this
recovery model all the activity inside the
database is logged. So you have schedule a transaction log backup to clear
of the trasnaction logs. THis backup can
be used when a recovery is needed.
Show to set to simple
ALTER database <dbname> set recovery SIMPLE
How to clear the existing logs and shrink the file:-
Since the file is really huge, I recomment you to set the database to single
user model before doing the below steps.
-- Setting database single user.
Alter database <dbname> set single_user with rollback immediate
-- Truncate the transaction log
BACKUP log <dbname> with truncate_only
-- shrink the transacton log file
DBCC SHRINKFILE('logical_ldf_name',truncateon
ly)
After doing the above steps execute the below command to see the transaction
log size and usage.
DBCC SQLPERF(LOGSPACE)
-- Now set the database multi user
Alter database <dbname> set multi_user
Thanks
Hari
MCDBA
"Lorena" <Lorena@.discussions.microsoft.com> wrote in message
news:6B7189C4-2904-4000-BD28-1A89C8BA9866@.microsoft.com...
> I Have a Database with a transaction log file 31 Gb, and I have problem
to backup it.
> I want decresea it but don't remember How.
> Lorena

How Can I reduce my transacion log file?

I Have a Database with a transaction log file 31 Gb, and I have problem to backup it.
I want decresea it but don't remember How.
Lorena
Hi,
It seems you have set recovery model for this database to FULL. In this
recovery model all the activity inside the
database is logged. So you have schedule a transaction log backup to clear
of the trasnaction logs. THis backup can
be used when a recovery is needed.
Show to set to simple
ALTER database <dbname> set recovery SIMPLE
How to clear the existing logs and shrink the file:-
Since the file is really huge, I recomment you to set the database to single
user model before doing the below steps.
-- Setting database single user.
Alter database <dbname> set single_user with rollback immediate
-- Truncate the transaction log
BACKUP log <dbname> with truncate_only
-- shrink the transacton log file
DBCC SHRINKFILE('logical_ldf_name',truncateonly)
After doing the above steps execute the below command to see the transaction
log size and usage.
DBCC SQLPERF(LOGSPACE)
-- Now set the database multi user
Alter database <dbname> set multi_user
Thanks
Hari
MCDBA
"Lorena" <Lorena@.discussions.microsoft.com> wrote in message
news:6B7189C4-2904-4000-BD28-1A89C8BA9866@.microsoft.com...
> I Have a Database with a transaction log file 31 Gb, and I have problem
to backup it.
> I want decresea it but don't remember How.
> Lorena

How can I reduce My Database 1G to 700MB....

HI...
I want to make Backup cd(700MB).. but My Database is more Bic 1G over.
How can I reduce My Database less than 700MB.
I using MS SQL 2000 Server...
Hi,
Pls. look my reply to your previous post
Thanks
Hari
MCDBA
"Basic SQL SERVER User" <z9813027@.daum.net> wrote in message
news:CB4B5DCA-9F09-4438-B00F-D4B7C602DA01@.microsoft.com...
> HI...
> I want to make Backup cd(700MB).. but My Database is more Bic 1G over.
> How can I reduce My Database less than 700MB.
> I using MS SQL 2000 Server...

How can I reduce My Database 1G to 700MB....

HI...
I want to make Backup cd(700MB).. but My Database is more Bic 1G over.
How can I reduce My Database less than 700MB.
I using MS SQL 2000 Server...Hi,
Pls. look my reply to your previous post
Thanks
Hari
MCDBA
"Basic SQL SERVER User" <z9813027@.daum.net> wrote in message
news:CB4B5DCA-9F09-4438-B00F-D4B7C602DA01@.microsoft.com...
> HI...
> I want to make Backup cd(700MB).. but My Database is more Bic 1G over.
> How can I reduce My Database less than 700MB.
> I using MS SQL 2000 Server...sql

How can I reduce My Database 1G to 700MB....

HI...
I want to make Backup cd(700MB).. but My Database is more Bic 1G over
How can I reduce My Database less than 700MB.
I using MS SQL 2000 Server...Hi,
Pls. look my reply to your previous post
--
Thanks
Hari
MCDBA
"Basic SQL SERVER User" <z9813027@.daum.net> wrote in message
news:CB4B5DCA-9F09-4438-B00F-D4B7C602DA01@.microsoft.com...
> HI...
> I want to make Backup cd(700MB).. but My Database is more Bic 1G over.
> How can I reduce My Database less than 700MB.
> I using MS SQL 2000 Server...

How Can I recover master database from master's backup?

I did a new instalation, and I want to recover master
database from master's backup, but the system show me the
next message RESTORE DATABASE must be in single user mode
when trying to restore the master database.
It's very important to me get information about the
aplication's users but I can't do that.
The system don't permit to put in single user mode to
master then I don't no what to do for resolving this.
Somebody Help me ?
Thanks LorenaSee my other post. No need to re-post.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Lorena" <anonymous@.discussions.microsoft.com> wrote in message
news:bba401c40dea$4e4130a0$a001280a@.phx.gbl...
> I did a new instalation, and I want to recover master
> database from master's backup, but the system show me the
> next message RESTORE DATABASE must be in single user mode
> when trying to restore the master database.
> It's very important to me get information about the
> aplication's users but I can't do that.
> The system don't permit to put in single user mode to
> master then I don't no what to do for resolving this.
> Somebody Help me ?
> Thanks Lorena
>sql

How can I move/import .MDF file to another machine ?

Our SQL Server machine just crashed, but I can get to the .MDF file (not a
backup file). If I have the .MDF file of a SQL Server database, can I import
this file to another SQL Server and look at it at the new machine ?
Thanks.If the SQL Server crashed in a weird state, you MIGHT be able to recover the
file.
Copy the MDF and LDF files to the other machine, and try attaching them.
(Look at sp_attach_db in Books Online).
If that fails, you can try just the MDF file, using sp_attach_single_file_db
(also documented in books online).
If that also fails, then you might have just learned the value of backups.
Better late than never. :-)
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Paul fpvt2" <Paulfpvt2@.discussions.microsoft.com> wrote in message
news:79A8EE21-766E-4172-A5BE-E395C66BCBB5@.microsoft.com...
> Our SQL Server machine just crashed, but I can get to the .MDF file (not a
> backup file). If I have the .MDF file of a SQL Server database, can I
import
> this file to another SQL Server and look at it at the new machine ?
> Thanks.|||Thank you.
I do not have the LDF file, and when I tried sp_attach_single_file_db
I got an error saying something like the MDF file does not have the right
format, or something like that.
I already recommend them to backup next time.
Thank you for your help.
"Aaron [SQL Server MVP]" wrote:
> If the SQL Server crashed in a weird state, you MIGHT be able to recover the
> file.
> Copy the MDF and LDF files to the other machine, and try attaching them.
> (Look at sp_attach_db in Books Online).
> If that fails, you can try just the MDF file, using sp_attach_single_file_db
> (also documented in books online).
> If that also fails, then you might have just learned the value of backups.
> Better late than never. :-)
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Paul fpvt2" <Paulfpvt2@.discussions.microsoft.com> wrote in message
> news:79A8EE21-766E-4172-A5BE-E395C66BCBB5@.microsoft.com...
> > Our SQL Server machine just crashed, but I can get to the .MDF file (not a
> > backup file). If I have the .MDF file of a SQL Server database, can I
> import
> > this file to another SQL Server and look at it at the new machine ?
> > Thanks.
>
>|||See if this helps:
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
This is why Backups are so important.
--
Andrew J. Kelly SQL MVP
"Paul fpvt2" <Paulfpvt2@.discussions.microsoft.com> wrote in message
news:7E0625EA-A06C-49B4-833A-232C4B11DAC5@.microsoft.com...
> Thank you.
> I do not have the LDF file, and when I tried sp_attach_single_file_db
> I got an error saying something like the MDF file does not have the right
> format, or something like that.
> I already recommend them to backup next time.
> Thank you for your help.
> "Aaron [SQL Server MVP]" wrote:
>> If the SQL Server crashed in a weird state, you MIGHT be able to recover
>> the
>> file.
>> Copy the MDF and LDF files to the other machine, and try attaching them.
>> (Look at sp_attach_db in Books Online).
>> If that fails, you can try just the MDF file, using
>> sp_attach_single_file_db
>> (also documented in books online).
>> If that also fails, then you might have just learned the value of
>> backups.
>> Better late than never. :-)
>> --
>> http://www.aspfaq.com/
>> (Reverse address to reply.)
>>
>>
>> "Paul fpvt2" <Paulfpvt2@.discussions.microsoft.com> wrote in message
>> news:79A8EE21-766E-4172-A5BE-E395C66BCBB5@.microsoft.com...
>> > Our SQL Server machine just crashed, but I can get to the .MDF file
>> > (not a
>> > backup file). If I have the .MDF file of a SQL Server database, can I
>> import
>> > this file to another SQL Server and look at it at the new machine ?
>> > Thanks.
>>

How can I make SQL Server automatic generate scheme script for backup everyday?

How can I make SQL Server automatic generate scheme script for backup
everyday?Google "scptxfr.exe". It's a tool from Microsoft used in the Upgrade
process, but it'll work for this.
see
http://www.databasejournal.com/feat...10894_3401081_1
for an example.
HTH,
Stu|||Wow, so fast replied. Very thanks
"Stu" <stuart.ainsworth@.gmail.com> wrote in message
news:1133921881.553339.60870@.g43g2000cwa.googlegroups.com...
> Google "scptxfr.exe". It's a tool from Microsoft used in the Upgrade
> process, but it'll work for this.
> see
> http://www.databasejournal.com/feat...10894_3401081_1
> for an example.
> HTH,
> Stu
>sql

How can I make SQL Server 2005 automatic generate scheme script for backup everyday?

How can I make SQL Server 2005 automatic generate scheme script for backup
everyday?"ABC" <abc@.abc.com> wrote in message
news:ef5YwPOEGHA.1312@.TK2MSFTNGP09.phx.gbl...
> How can I make SQL Server 2005 automatic generate scheme script for backup
> everyday?
>
>
I believe you could use the SMO Scripter class to achieve this.
If your schema is in development I'd recommend you use a source control
program to backup the source code. Or you can use utilities like DBGhost or
RedGate SQL Compare to script the changes.
David Portas
SQL Server MVP
--

How can I get the log sequence number on C#?

Hi! I would like to get the log sequence number from the database backup so
that I can let the users select the restored time. Can I do this with the
SMO?
Thanks!One way would be to use methods such as the Database.ExecuteWithResults method to execute your
RESTORE HEADERONLY command and loop the result (DataTable in the DataSet) from that method.
Or, you should be able to use BackupDevice.ReadBackupHeader method and read the returned DataTable.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Cheryl" <justtosayhi@.excite.com> wrote in message
news:FBB10E85-25FF-49B7-96D4-97ADE7552575@.microsoft.com...
> Hi! I would like to get the log sequence number from the database backup so that I can let the
> users select the restored time. Can I do this with the SMO?
> Thanks!

How Can i Get a list of Back devices

Hi All,,

I want to get a list of backup devices for a selected database
ex :
Northwind Database i need to get the list of back devices for this db
any one know how the query could be written

best regards

Wafi MohtasebDoessp_helpdevice give you what you are looking for?

Terri