Create standby database without backup/restore

I would like to create a standby database without backup restore.

We currently have a continous access storage ( disk duplication)but I would like to change to logshipping instead.

The database is 1 TB large and backup and restoring would take at least 2 days.

And we already have the datafile duplicated , soI would like to use these datafiles.

How can this be done?

Have you tried to issue:

BACKUP DATABASE <mydatabase> WITH NORECOVERY

This will place the database in a recovering state where you can apply transaction logs, as long as you have log backups which contain the next LSN needing to be applied.

Create database fails because of lack of disk space...

Hi,
I'm getting strange thing here.
CREATE DATABASE fails ("CREATE DATABASE failed. Could not
allocate enough disk space for a new database on the
named disks. Total space allocated must be at least 2 MB
to accommodate a copy of the model database."), and I
have almost 8GB of free space on that drive.
CREATE DATABASE [GTO] ON (NAME = N'GTO_Data', FILENAME =
N'E:\mssql\data\GTO_Data.MDF' , SIZE = 1, FILEGROWTH =
10%) LOG ON (NAME = N'GTO_Log', FILENAME =
N'E:\mssql\data\GTO_Log.LDF' , SIZE = 1, FILEGROWTH = 10%)
Output od xp_fixeddrives[MB]:
C2312
D5539
E7801
F10228
G11130
I38801
Does anybody have an idea what's going on?
Thanks,
OJ
Is it possible you have disk quotas enabled, or that E:\ is a compressed
volume?
http://www.aspfaq.com/
(Reverse address to reply.)
"OJ" <anonymous@.discussions.microsoft.com> wrote in message
news:2d2201c470ca$8990a800$a601280a@.phx.gbl...
> Hi,
> I'm getting strange thing here.
> CREATE DATABASE fails ("CREATE DATABASE failed. Could not
> allocate enough disk space for a new database on the
> named disks. Total space allocated must be at least 2 MB
> to accommodate a copy of the model database."), and I
> have almost 8GB of free space on that drive.
> CREATE DATABASE [GTO] ON (NAME = N'GTO_Data', FILENAME =
> N'E:\mssql\data\GTO_Data.MDF' , SIZE = 1, FILEGROWTH =
> 10%) LOG ON (NAME = N'GTO_Log', FILENAME =
> N'E:\mssql\data\GTO_Log.LDF' , SIZE = 1, FILEGROWTH = 10%)
> Output od xp_fixeddrives[MB]:
> --
> C 2312
> D 5539
> E 7801
> F 10228
> G 11130
> I 38801
> Does anybody have an idea what's going on?
> Thanks,
> OJ
|||No and no.
OJ
>--Original Message--
>Is it possible you have disk quotas enabled, or that E:\
is a compressed
>volume?
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>
>"OJ" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:2d2201c470ca$8990a800$a601280a@.phx.gbl...
not[vbcol=seagreen]
MB[vbcol=seagreen]
FILENAME =[vbcol=seagreen]
10%)
>
>.
>
|||Well, I don't have any other suggestions, maybe you should call PSS. To
avoid embarrassment, make sure that the xp_fixeddrives call is truly being
made on the same server.
http://www.aspfaq.com/
(Reverse address to reply.)
"OJ" <anonymous@.discussions.microsoft.com> wrote in message
news:30f201c470dd$b01efa40$a501280a@.phx.gbl...[vbcol=seagreen]
> No and no.
> OJ
> is a compressed
|||Can you delete something on that E: drive that's larger than 2 MB and run
the script again? I've never seen things like that so just shooting in the
dark. Is it possible that SQL server gets really funky and doesn't read OS
level the same as xp does? Or a backup that took 8 GB or so got currupted
halfway, causing SQL server to still think the disk drive is full?
I'd just give the server a clean reboot before making a PSS call.
"OJ" <anonymous@.discussions.microsoft.com> wrote in message
news:2d2201c470ca$8990a800$a601280a@.phx.gbl...
> Hi,
> I'm getting strange thing here.
> CREATE DATABASE fails ("CREATE DATABASE failed. Could not
> allocate enough disk space for a new database on the
> named disks. Total space allocated must be at least 2 MB
> to accommodate a copy of the model database."), and I
> have almost 8GB of free space on that drive.
> CREATE DATABASE [GTO] ON (NAME = N'GTO_Data', FILENAME =
> N'E:\mssql\data\GTO_Data.MDF' , SIZE = 1, FILEGROWTH =
> 10%) LOG ON (NAME = N'GTO_Log', FILENAME =
> N'E:\mssql\data\GTO_Log.LDF' , SIZE = 1, FILEGROWTH = 10%)
> Output od xp_fixeddrives[MB]:
> --
> C 2312
> D 5539
> E 7801
> F 10228
> G 11130
> I 38801
> Does anybody have an idea what's going on?
> Thanks,
> OJ
|||It's embarrasing but not from that reason.
Somebody changed MODEL database size to 2MB. My "create
database" statement has 1MB as data file size. As soon as
I changed that to 3MB, everything worked out OK...
OJ
>--Original Message--
>Well, I don't have any other suggestions, maybe you
should call PSS. To
>avoid embarrassment, make sure that the xp_fixeddrives
call is truly being
>made on the same server.
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>
>"OJ" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:30f201c470dd$b01efa40$a501280a@.phx.gbl...
E:\
>
>.
>

Create database fails because of lack of disk space...

Hi,
I'm getting strange thing here.
CREATE DATABASE fails ("CREATE DATABASE failed. Could not
allocate enough disk space for a new database on the
named disks. Total space allocated must be at least 2 MB
to accommodate a copy of the model database."), and I
have almost 8GB of free space on that drive.
CREATE DATABASE [GTO] ON (NAME = N'GTO_Data', FILENAME =
N'E:\mssql\data\GTO_Data.MDF' , SIZE = 1, FILEGROWTH =
10%) LOG ON (NAME = N'GTO_Log', FILENAME =
N'E:\mssql\data\GTO_Log.LDF' , SIZE = 1, FILEGROWTH = 10%)
Output od xp_fixeddrives[MB]:
--
C 2312
D 5539
E 7801
F 10228
G 11130
I 38801
Does anybody have an idea what's going on?
Thanks,
OJIs it possible you have disk quotas enabled, or that E:\ is a compressed
volume?
http://www.aspfaq.com/
(Reverse address to reply.)
"OJ" <anonymous@.discussions.microsoft.com> wrote in message
news:2d2201c470ca$8990a800$a601280a@.phx.gbl...
> Hi,
> I'm getting strange thing here.
> CREATE DATABASE fails ("CREATE DATABASE failed. Could not
> allocate enough disk space for a new database on the
> named disks. Total space allocated must be at least 2 MB
> to accommodate a copy of the model database."), and I
> have almost 8GB of free space on that drive.
> CREATE DATABASE [GTO] ON (NAME = N'GTO_Data', FILENAME =
> N'E:\mssql\data\GTO_Data.MDF' , SIZE = 1, FILEGROWTH =
> 10%) LOG ON (NAME = N'GTO_Log', FILENAME =
> N'E:\mssql\data\GTO_Log.LDF' , SIZE = 1, FILEGROWTH = 10%)
> Output od xp_fixeddrives[MB]:
> --
> C 2312
> D 5539
> E 7801
> F 10228
> G 11130
> I 38801
> Does anybody have an idea what's going on?
> Thanks,
> OJ|||No and no.
OJ
>--Original Message--
>Is it possible you have disk quotas enabled, or that E:\
is a compressed
>volume?
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>
>"OJ" <anonymous@.discussions.microsoft.com> wrote in
message
>news:2d2201c470ca$8990a800$a601280a@.phx.gbl...
not[vbcol=seagreen]
MB[vbcol=seagreen]
FILENAME =[vbcol=seagreen]
10%)[vbcol=seagreen]
>
>.
>|||Well, I don't have any other suggestions, maybe you should call PSS. To
avoid embarrassment, make sure that the xp_fixeddrives call is truly being
made on the same server.
http://www.aspfaq.com/
(Reverse address to reply.)
"OJ" <anonymous@.discussions.microsoft.com> wrote in message
news:30f201c470dd$b01efa40$a501280a@.phx.gbl...[vbcol=seagreen]
> No and no.
> OJ
> is a compressed|||Can you delete something on that E: drive that's larger than 2 MB and run
the script again? I've never seen things like that so just shooting in the
dark. Is it possible that SQL server gets really funky and doesn't read OS
level the same as xp does? Or a backup that took 8 GB or so got currupted
halfway, causing SQL server to still think the disk drive is full?
I'd just give the server a clean reboot before making a PSS call.
"OJ" <anonymous@.discussions.microsoft.com> wrote in message
news:2d2201c470ca$8990a800$a601280a@.phx.gbl...
> Hi,
> I'm getting strange thing here.
> CREATE DATABASE fails ("CREATE DATABASE failed. Could not
> allocate enough disk space for a new database on the
> named disks. Total space allocated must be at least 2 MB
> to accommodate a copy of the model database."), and I
> have almost 8GB of free space on that drive.
> CREATE DATABASE [GTO] ON (NAME = N'GTO_Data', FILENAME =
> N'E:\mssql\data\GTO_Data.MDF' , SIZE = 1, FILEGROWTH =
> 10%) LOG ON (NAME = N'GTO_Log', FILENAME =
> N'E:\mssql\data\GTO_Log.LDF' , SIZE = 1, FILEGROWTH = 10%)
> Output od xp_fixeddrives[MB]:
> --
> C 2312
> D 5539
> E 7801
> F 10228
> G 11130
> I 38801
> Does anybody have an idea what's going on?
> Thanks,
> OJ|||It's embarrasing but not from that reason.
Somebody changed MODEL database size to 2MB. My "create
database" statement has 1MB as data file size. As soon as
I changed that to 3MB, everything worked out OK...
OJ
>--Original Message--
>Well, I don't have any other suggestions, maybe you
should call PSS. To
>avoid embarrassment, make sure that the xp_fixeddrives
call is truly being
>made on the same server.
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>
>"OJ" <anonymous@.discussions.microsoft.com> wrote in
message
>news:30f201c470dd$b01efa40$a501280a@.phx.gbl...
E:\[vbcol=seagreen]
>
>.
>