SQL SERVER BACKUP Problem In Different DEVICES
Jul 23, 2005
Hi there,
I need to take a backup with the following scanerio in mind:
At T1 I take the FULL BACK UP of the database called BACK_1_FULL.BACK in
c:
Then at T2 I would like to take only the differential BACKUP of the
Transaction log called BACK_1_TRANSLOG.BACK and at T3 I would like to
take
only the differential BACKUP of the Transaction log called
BACK_2_TRANSLOG.BACK. At T4 my system fails and I need to bring the
database
to a point where my T3 state is in. I tried taking the backups in DEVICE
but
I always get an error from SQL Server Enterprise manager such as
Volume on Device 'Device2' is not part of a family media set. BACKUP
WITH NO
FORMAT can be used to form a new media set. BACKUP LOG is terminating
abnormally.
If someone can give suggestions on how to backup and restore in this
situation it will be really helpful.
Thanks
John
*** Sent via Developersdex http://www.developersdex.com ***
View 1 Replies
ADVERTISEMENT
Nov 4, 2000
hi, I usually back up the database to a file within the sql server box. then use a tape backup to back up the whole directory of the sql server in the d: drive.
Is this right way to do or there is a better way ?
Ahmed
View 1 Replies
View Related
Jul 28, 2000
I have taken backups and the backup devices are stored in C: drive and now i want them to be moved onto the other drive.So how can i do it without creating new devices and scheduling them again.
Any help would be appreciated.
Thanks,
Kris
View 2 Replies
View Related
Aug 11, 2000
i need to initialise the backup devices as the the backup files have grown so big thats its occupy hard drive space , each device is for @ day for all databse we use , what do i do
thanks
safac
View 1 Replies
View Related
Jun 11, 2004
Hi guys
I am relatively new to SQL Server admin and I have been handed a task of creating backup devices for a particular SQL Server which has 204 databases.
Rather than go through and create Full, Incramental and Transaction Log backup devices for each database is ther anyway of doing the following
Create a script to go through and for each database name in 'sysdatabases'
create a folder e.g sqldataackup\%databasename%
and within each folder create a backup device called
%databasename%_full
%databasename%_inc
%databasename%_log
Also all these databases are running in 'Simple' recovery mode so obviously I need to change this to 'Full' to enable incramental and log backups - is this possible using the same script.
Hope someone can help as the thought of doing all of this individually for each database scares me silly!!! :)
Thanks in advance for any help
Hanley
View 5 Replies
View Related
Sep 28, 2006
Hi,
I am using EMS SQL Manager for SQL Server (www.sqlmanager.net). I am trying to learn how to do backups of my database.
I am up to this step -> http://www.sqlmanager.net/products/mssql/manager/documentation/hs21640.html
I don't think I actually understand what a device is, how it's created, where it resides, etc. I would like to backup my remote datasource to my local computer's harddrive.
Can someone please explain how this 'device' works and how I should set up?
Thank you so much for any help :-)
jo
View 9 Replies
View Related
Jan 12, 2000
Hello,
I am using EM to administer SQL 6.5 SP5a and have a few dBs that do not show backup history by expanding the backup device. The server is regestered as SA and MSDB does contain the the correct data in the sysbackuphistory table. MSDB DBCCs OK and other dBs show history. I manage multiple SQL 6.5 servers but this is the first time I've seen this and can find no info in the various KBs or NGs..
Anyone have any clues?
Thanks,
Jack
View 3 Replies
View Related
Jun 16, 2001
If I'm not mistaken, we can create a backup device OR backup files in SQL7. Can someone tell me which one is better?
View 1 Replies
View Related
Mar 29, 2004
Hello--
I am trying to backup a VLDB (800+gig) to multiple devices. I am using 4 disk drives. Assuming all devices have the same performance, should the 4 devices fill equally? (IE 200gig per drive) If so, what would might happen if one of the 4 drives only has 100 gig free with the other 3 having 300 gig free each?
Thanks for the help--
Jeff
View 2 Replies
View Related
Mar 11, 1999
Hi, I've to restore a bk into a new DB, because the old one has a lot of devices created on different places and phisical disks.
Im not sure to do that, cause Ive heard some problems with this action.
The old Db has 10 devices of data and 10 devices of log, and I want to create only one device of data (sum of all the data devices) and only one device of log (sum of all log devices)
Is it possible or not?
Tnx a lot!
View 2 Replies
View Related
Jul 1, 2015
I have a database size of 9.8TB and I backup it to 30 backup devices. Each one has 110GB after backup compression.I tried to restore these files to standby server via 100MbE network but it always failed. My colleague told me this never happen before and I said yes because I have done this before a lot of times when backup devices are significantly smaller.He said the only way is to copy backup files locally and restore locally. But I am trying another method, I create more: 64(maximum) backup devices and try to restore via network again.SQL server version is Microsoft SQL Server 2012 (SP1)
- 11.0.3401.0 (X64) Jan 9 2014 13:22:15 Copyright (c) Microsoft Corporation
Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.1 <X64> (Build 7601:
Service Pack 1) .
--- error message ---
5 percent processed.
10 percent processed.
15 percent processed.
[code]....
RESTORE DATABASE is terminating abnormally.
View 11 Replies
View Related
Aug 20, 2007
I am getting an error, "Set property Devices to accomplish this action." when doing a backup with SQL Server 2005 Express when I try to do a full (or Differential) backup through the SQL Server Management Studio. I'm using the backup defaults in the GUI and was able to back up the database a couple of days ago without any problem. Today (second time) it just comes up with this error and I have been able to find anything that talks about what it might be.
I tired to look at the script by using the "Script action to new query, file, clipboard, etc." but it fails before it creates the script in any destination. I've rebooted the server and that didn't help.
I found one similar post on this forum but it had no resolution. Any direction on this problem would be greatly appreciated.
Thank you,
Steve
View 10 Replies
View Related
Oct 18, 2015
I'm trying to restore a database using SSMS GUI. In "Select backup devices" window if I click the Add button there the window and the whole process hangs like it will never work.
I tried to clear backup history, but that didn't solve it.
I tried with a couple of other databases, but same thing. It was working fine!
View 9 Replies
View Related
Nov 30, 2001
Does anyone out there use a NAS device to place there database and corresponding images on?
View 2 Replies
View Related
Nov 28, 2006
I Have a smart device application developed in VS 2003 (VB.Net) and Sql server ce 2.0. Now I have upgraded the application to VS 2005 (VB.Net). My question is, Can the Application developed in VS 2005 can communicate with Sql server ce 2.0 and Sql server 2000 sp4 or Do I need to change the Sql server ce 2.0 to sql server 3.0 to work with windows Mobile 5 and Pocket PC 2003 SE devices ?
View 3 Replies
View Related
Dec 28, 2006
Please add some more substantial needed info in ALL the web pages of "SQL Server 2005 Compact Edition RC1, Release Candidate 1", like at:
http://support.microsoft.com/kb/920700
for:
1) Clarifying the confusing name changes of the Mobile Edition to Everywhere Edition then to CE,
2) Giving installion instructions of the RC1 for mobile devices
Thanks,
Alpoge
View 3 Replies
View Related
Oct 20, 2000
I know that you need to create a device in 6.5 to do backups, but in 7.0, it seems to take care of this for you. However, there is still a device folder in the Management folder of version 7.0's console tree. Why would it be better to back up to devices, rather than anywhere else on the hard drive. Is there any way to easily schedule the deletion of backups on these devices? I know that with 7.0's Maintenance plans, you can schedule old backups to be deleted. But how do you do that for devices?
joe
View 2 Replies
View Related
Oct 31, 2001
How do I create more than 10 devices in sql server 4.2?
View 2 Replies
View Related
Aug 14, 2007
Hello
I just tried to make a typed resultset from a SSCE v3.5 database, and recieved this message from Visual Studio:
"Typed ResultSets cannot be generated for tables on Microsoft SQL Server Compact 3.5 databases present on devices."
On the device, speed and low memory consumption is important. So it seems to me that this should be present ONLY on devices, because on the desktop we can just use the DataSet generator and not care about the overhead.
Anyway, ripped from what would have been a nice feature, the alternatives that comes to mind are:
1. Making my own resultset generator
2. Use typed DataSets
3. Derive from SqlCeResultSet and store the Field names in it, to build my own typed resultset class.
Any suggestions on what to do?
View 6 Replies
View Related
Jul 2, 2007
I asked about this a few mos ago over in the CF forum, but I'm hoping there's a better solution someone (Erik?) knows about here.
Is there a "standard" deploy script for SQL Server CE on devices? There doesn't even seem to be one in the d/l from Microsoft. During development, Visual Studio handles the installation of SQL Server CE on the device but deploying it on a device that isn't partnered to a dev box seems to be a matter of "just copy the cab file over".
While I'm willing to do that if I have to, it raises some other questions. How do I know if it's already there? How do I know if what's there is a newer version or not (and if it is, how do I abort this step)? How do I make sure some other application hasn't installed it already? Do I really even need to worry this?
I can just have my installer tell ActiveSync to put it on the device, but without knowing the above I'm kind of nervous about it.
View 4 Replies
View Related
Apr 17, 2004
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 Mohtaseb
View 1 Replies
View Related
Sep 14, 1998
Hello
Does anyone have experience/advice with large databases (5-10 Gig)? If so, I was wondering about
performance/other benefits of spanning a large database across multiple devices (different disks). Would anyone
vote for or against doing this?
Suggestions...
Thanks
Tim
View 1 Replies
View Related
Oct 21, 1998
Hi all
I have a raid 5 NT server 4.0 with SQL 6.5 running.
I perform backups on tranlogs every hour and db`s every night.
I also have another 16G Nt server not raid 5.
Can someone tell me if it is possible to mirror a device or a database
into the regular 16G NT server from raid 5 server?
HOW???
HOw about database mirroring??
And also whats the best solution when it comes to mirrorring in NT server?
View 1 Replies
View Related
Jun 9, 1999
Hello All,
I want to know if it's possible for a database on multiple devices to put specific tables on specific devices?? and if this is possible how to do it??
Thanks for help
Mohamed hani
View 1 Replies
View Related
Nov 6, 2007
Hi all,
Can somebody tell me how to display reports created in SSRS 2005 in PDA/mobile devices? How to connect to the PDA device?
View 7 Replies
View Related
Sep 17, 2001
I am new to SS7. We are planning to rearrange our system databases so that the logs are on one drive
and the data files are on a different drive. I found a really good white paper on this but just want to
verify that there is not a problem with doing this. In sybase there were some restrictions on doing this.
Any info you have would be appreciated.
View 3 Replies
View Related
May 3, 1999
Is there a way to shrink database devices in SQL Server 6.5 Other than dropping and restoring?
View 1 Replies
View Related
Sep 25, 1999
Hi am new to this, I am doing some asp development and wanted to know if there is a way of specifying the drive to place log and data devices through sql statments or stored procedures.
--Tito
View 1 Replies
View Related
Nov 6, 1999
Just wondering - on a straight RAID 5 system is there any advantage, performance or otherwise, to splitting a SQL 6.5 database over multiple database devices? Or for simplicity's sake am I just further off creating a single device and manually extending it as the database grows?
Thanks
RM
View 1 Replies
View Related
Jun 27, 2006
Dear all:
Is there a way to connect to a SQL Server mobile using native code C++?
I don't want to use the Compact Framework to access Data.
Does anybody knows how to connect to an SQLite database from VS2005 c++ for devices?
Thanks.
Alfredo Mendiola Loyola
Lima Perú
View 4 Replies
View Related
Feb 18, 2015
SQL Server 2008 r2 - 6 GB memory...I attempted a backup on a 500GB database but it was taking way too long. I checked the resources on the box and saw the CPU at 100%. I checked the SQL Server activity log and saw a hung query (user was not even logged on) that had multiple threads so I killed it and now the CPU utilization is back to normal.
Trouble is, now all of the threads in the activity monitor for the backup show 'suspended' and the backup appears to be not doing anything.
View 3 Replies
View Related
Aug 3, 2015
Need to restore database,here's the scenario:
Data got deleted on Friday evening, need to have database restored to FRiday afternoon and also some data has been entered on Monday, which needs to be there.
View 8 Replies
View Related
Dec 28, 2007
Windows 2003 backup utility uses the shadow copy option that allows it to copy open files.
Therefore, can I use this utility to backup the .mdf and .ldf files for my SQL 2000 database?
I can then attach the .mdf files if I need to restore the database to another server.
Can anyone tell me if this is safe? I've tried it and it worked but I'm worried there maybe some lurking danger in using this approach.
View 4 Replies
View Related
